Viewing 15 posts - 9,616 through 9,630 (of 11,678 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...
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...
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...
April 10, 2011 at 11:56 pm
Nice article, thanks Andy. I can't wait to see the rest of the series.
April 10, 2011 at 11:42 pm
Jeff Moden (4/1/2011)
April 2, 2011 at 2:48 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.
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...
April 1, 2011 at 3:42 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.

April 1, 2011 at 2:06 am
Viewing 15 posts - 9,616 through 9,630 (of 11,678 total)