Dineshasanka, If you click on the link in the article, Mapping Data Types in the Data Flow, you will see the list I emailed above. I do not see a...
Dineshasanka, I do not have any of these data types listed in the drop down menu in the variable section in SSIS. I have Boolean, Byte, Char,...
I'll take a look. Thanks for your help. For now, I am passing the value in as a string and then converting it in a stored proc that I use later on....
Does anyone know what datatype in SSIS is equal to SQL Servers smallmoney? I have a sql task and I'm trying to put my result set (a smallmoney SQL...
Thanks MohammedU. That's what I thought, but I wasn't sure. I did run DBCC CHECKDB and no errors were returned. Thanks Deepak. This is exactly...
Can someone tell me what my have caused this to happen? If I run the query below in one of my databases I get 67 rows returned and there should only...
Satya, Thanks for the link. I'll take a look. Andy
Can someone tell me what components are installed with SQL Server Analysis Services in SQL Server 2005? I'm trying to make sure that our admin...
MohammedU, Thank you for the two links. This was exactly the type of information I was looking for. Andy
I have the same question except it will be on a SAN. Is there a checklist of things to make sure you do when setting up a SQL Server 2005 database...
merrillaldrich, Thank you for your reply. I was just not sure if this was a good idea from a design stand point. Thanks again. Andy
I have a data modeling question and I didn't know where to go for help and everyone on this site is so helpful that I thought I had to try here. I...
I'm trying to create an SSIS package that will drop a table if it exists on server B(destination), then copy the table from server A(source) to...
I figured it out. The batch jobs were not changed. They were still pointing to the old instance therefore the bcp was trying to load data into the...
Brad, Here's some additional info. Step 4 runs EXEC CSP_CT_81(a stored proc) to drop and create tables. Step 5 runs EXEC MSDB..SP_START_JOB...
Brad, I've very new to sql server jobs. I do have them set to produce an output file. Is this what you mean by a log? If so I can post that...
I moved some jobs to a new instance of SQL Server 2000. I ran the jobs last night and several failed. In the first job, the first three steps ran...
Thank you. I have read some in the sql server help file. I just needed a quick answer and I knew this site would help. Thanks again. Andy
Can someone tell me how to reclaim the unused space in a database? I have all ready run DBCC Shrinkfile and DBCC Shrinkdatabase with truncateonly....
I'm running a restore to restore a database. I have to restore the database and then DTS the tables I need to an existing database. Is it possible...
Separate names with a comma.
