To give some sort of general definition of SSIS:

SSIS is an ETL tool. If you don't know what ETL is, search it on wikipedia.

It reads data from a source, then...

Well, the problem is quite obvious and the error message is quite clear:

no excel support for 64-bit. So it is not an error, it is by design 🙂

Luckily, the solution...

You can't dynamically assign tables to a data flow. SSIS will mess up the metadata, which results in the errors that you saw. A data flow has to be static...

Hugo Kornelis (7/7/2010)

---

UMG Developer (7/6/2010)

---

Nice question, thanks!

I'm a little surprised that so many people have gotten it correct so far, but that may be because of the copy, paste, F5...

Nice question to point out the difference between temp table and table variable, but a little more explanation would be helpful (such as a link to a BOL article).

As a junior BI consultant I'm still in the learning curve for SQL Server.

A few months back I was preparing a deployment of an ETL project that I wrote. I...

Elliot is right, you can't do it with out-of-the-box components.

However, you can achieve it with smart T-SQL scripting.

Create a transfer list of all the tables that you want to load....

Can you elaborate?

Going...

I was thinking the same thing. As your package...

Sometimes they ask stupid questions, just...

You could write the exception stream to a temp/staging table.

Then, check the rowcount of this table and store the result in a variable. Use this variable in a precedence constraint...

That simply means that the column with ID 6493 contains data that is larger than the length you specified.

You can either solve the issue by making sure that your source...

Great question about an undocumented feature!

In Excel, 0 equals FALSE for boolean values, and any other number equals TRUE.

However, I believe that Excel stores a boolean default as -1.

So, theoretically, nothing is wrong with your...