Viewing 15 posts - 9,136 through 9,150 (of 11,676 total)
+1 for Phil.
Do not double click on the .csv file, it will open up Excel as the editor (ugh. Excel even sometimes screws up the CSV format).
July 27, 2011 at 1:54 am
Looking at the error message, there isn't a problem with the SCD but a problem with the rowcount component. Apparently there isn't a variable assigned to that component.
July 27, 2011 at 1:48 am
To use variables in an Execute SQL Task, you need to map the package variable in the parameters tab to an OLE DB parameter. From your explanation I see you...
July 27, 2011 at 1:44 am
Why don't you execute the SQL statement directly in an OLE DB source instead of an Execute SQL Task?
July 27, 2011 at 1:37 am
SQLRNNR (7/20/2011)
Yes. It's better to install both, but the Bus. Intelligence stuff (SSIS) comes from the SQL media.
To expand on the answer:
* if you install VS 2008 first, as...
July 27, 2011 at 1:35 am
Duplicate post. Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1146580-147-1.aspx
July 27, 2011 at 1:34 am
Sriram.RM (7/27/2011)
July 27, 2011 at 12:56 am
Great question! Not easy to spot, but hey, we like a little challenge 😀
July 26, 2011 at 3:09 am
Viewing 15 posts - 9,136 through 9,150 (of 11,676 total)