You are trying to set the wrong property.

With the expression that you created you should set the ExcelFilePath property.

The connection string has the following form:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\myServer\myExcelfile.xls";Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";

which is a...

A simple question, but a usefull one nonetheless, especially if you use the function with variables as input parameters.

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