keepintouch2b (4/7/2011)

---

So what is the final answer?

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...

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...

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...

Great question, thanks.

Nice question, thanks!

Nice question, thanks.

Nice article, thanks Andy. I can't wait to see the rest of the series.

Nice question, thanks.

Nice question, thanks.

Jeff Moden (4/1/2011)

---

As a bit of a side bar, notice that the current number of visits to SSC is precisely "1". The OP hasn't even checked to see if...

No download link? 😛

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.

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...

Woot woot! 7 easy points 😀