Viewing 15 posts - 9,616 through 9,630 (of 11,676 total)
keepintouch2b (4/7/2011)
Will SSIS 2008 package run with SQL Server 2005 DTExec?
Yes or No or Maybe Yes.
Regarding maybe Yes, I am referring to simple packages with...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 11, 2011 at 12:28 am
If all the tables are in the same SQL Server, write a TSQL query that joins all those tables together and retrieve the data you need in one single OLE...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 11, 2011 at 12:26 am
Another great article Andy!
I found it very nice that you gave some attention to the layout of the package, as unfortunately, messy control and data flows do appear in books...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 10, 2011 at 11:56 pm
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 10, 2011 at 11:51 pm
Nice question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 10, 2011 at 11:47 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 10, 2011 at 11:45 pm
Nice article, thanks Andy. I can't wait to see the rest of the series.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 10, 2011 at 11:42 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 10, 2011 at 11:39 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 10, 2011 at 11:37 pm
Jeff Moden (4/1/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 2, 2011 at 2:48 am
No download link? 😛
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 1, 2011 at 5:22 am
Regarding the SQL Server part: you should use NVARCHAR there.
Regarding the SSIS part: it should work when you use DT_WSTR, as it is the unicode datatype from SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 1, 2011 at 3:44 am
You can use a For Each Loop to loop over the folder and pick up each .csv file and process it seperately.
Use the For Each File enumeration with the following...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 1, 2011 at 3:42 am
Woot woot! 7 easy points 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 1, 2011 at 3:12 am
GSquared (3/31/2011)
I seriously can't believe Celko did this: http://www.sqlservercentral.com/Forums/Topic1087228-61-1.aspxI'm seriously hoping it's followed up with "April Fools!" or something. Just, wow, if not.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 1, 2011 at 2:06 am
Viewing 15 posts - 9,616 through 9,630 (of 11,676 total)