You could get all the files from the folder using a script task (use DirectoryInfo). Store these in a SQL table.

Retrieve them again using a SQL SELECT statement with an...

Right click on the control flow. Choose package configurations. Tick the checkbox at "Enable Package Configurations".

Click Add. In the editor, choose Parent Package Variable from the dropdown menu. Type the...

I just explained in another topic how such a thing can be done with standard components:

http://www.sqlservercentral.com/Forums/Topic1096064-148-1.aspx

Here is a pretty decent article:

http://www.ssistalk.com/2007/03/09/ssis-using-a-checksum-to-determine-if-a-row-has-changed/

(Googled on SSIS checksum transformation. 2nd result)

I would however advise you to just dump the SCD component, it is not peformant at all, which you...

Here you go:

http://msdn.microsoft.com/en-us/library/ms345179.aspx

Allright, I tried it out myself. I have an Excel sheet with a space in the name.

I can select the correct sheet from the dropdown, but I can't do a...

This was a bit easy 🙂

Find the answer by elimination...

OK, just to get things straight.

You are using .xls with the JET provider.

Everything works when you use the sheetname TEST, but the package fails when you use the original sheetname,...

So, if I'm not mistaken, you are using a .xlsx file, right?

If yes, you should use...

Brandie Tarvin (4/19/2011)

---

Some people are fond of doing this as multiple single INSERT statements (INSERT ... SELECT ...; INSERT .... SELECT ...;). Me, I like using 1 INSERT clause and...

About 2000 records (about 8 posts ago). Not really large, unless there are 500 columns 😀

Brandie Tarvin (4/19/2011)

---

Koen Verbeeck (4/19/2011)

---

What do you mean exactly? SQL dialects? Why not? This is a SQL Server forum, so there's nothing wrong with some...

The package already fails at validation. Does the package has permission to access the folder where the Excel file is stored?

The Excel file isn't locked by another process?

This may sound...

What do you mean exactly? SQL dialects? Why not? This is a SQL Server forum, so there's nothing wrong with some little T-SQL here and...

imani_technology (4/19/2011)

---

I corrected the SQL syntax so now it works.

SELECT [POS Report-XXXX BRANDS-YYYYYYYY$].*

FROM ...