Another cause of this error is someone managed to get a tab character into what is supposed to be a text file. In that case you may need to...

I also like to keep track of what row a record is in the dataset so I can report back where the problem is, which field, and the nature of...

That is what I suspected. Thanks!

Since the config file already exists, you can copy the code for one variable and change its name and value. You will need to figure out where one variable...

That sounds like it would work. Another possibility is to add each of the 5 keys to the dimension.

Are you conforming the information from the different databatases...

I tried saving the Excel file as 2007 format and the scientific notation bug went away.

What is the format of an Excel query that uses FORMAT?

Here are some rows from an Excel file that have the scientific notation problem. It is an .xls file.

NCPDP1

3356260

3329706

3350612

3350612

03350612

3337397

3313210

3340685

3332385

First, SSIS 2008 still has this problem.

We often receive Excel files where fields are strings of digits but leading zeroes must be preserved. There are also columns with mixed...

Thank you! That gives me ideas on how to work around this.

The rowcount should work. The value of the variable will remain zero until the data flow task completes. Then it should contain the final count. You might...

What about just using the script task to save the file names to a file. Then a data flow task could read each file name and assign its date....

You could dump it to a work table. Then do any parsing or reformatting and send it to the final tables.

Since it is ragged right, I assume this is...

Excel determines the data type of each column by looking at the first 8 rows. If some cells look like numbers and some look like text, it will choose...

In HNAECD!=@[User::strDept1]||HNAECD!=@[User::strDept2] etc.

switch from logical or (||) to logical and (&&).

HNAECD is not in (strDept1 OR strDept2 OR...)

is the same as

HNAECD is not in strDept1

AND HNAECD is not...

One approach is to create a boolean variable and set it to false before the for each loop. It will indicate if a file has been selected.

The first step...