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).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 27, 2011 at 1:34 am
Quick, easy, without thinking 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 27, 2011 at 1:10 am
Sriram.RM (7/27/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 27, 2011 at 12:56 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 27, 2011 at 12:54 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 26, 2011 at 3:19 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 26, 2011 at 3:17 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 26, 2011 at 3:13 am
Great question! Not easy to spot, but hey, we like a little challenge 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 26, 2011 at 3:09 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 26, 2011 at 3:03 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 26, 2011 at 3:01 am
Viewing 15 posts - 9,136 through 9,150 (of 11,676 total)