Viewing 15 posts - 1 through 15 (of 96 total)
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...
December 15, 2016 at 7:05 am
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...
July 1, 2016 at 5:44 am
That is what I suspected. Thanks!
April 8, 2015 at 9:14 pm
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...
April 7, 2015 at 9:21 am
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...
May 20, 2011 at 6:22 pm
I tried saving the Excel file as 2007 format and the scientific notation bug went away.
May 19, 2011 at 8:15 pm
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.
May 19, 2011 at 8:05 pm
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...
May 15, 2011 at 8:45 pm
Thank you! That gives me ideas on how to work around this.
September 13, 2010 at 7:42 am
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...
January 10, 2010 at 9:07 pm
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....
January 10, 2010 at 8:59 pm
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...
January 6, 2010 at 9:25 pm
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...
December 26, 2009 at 2:33 pm
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...
November 11, 2009 at 8:52 pm
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...
November 11, 2009 at 8:20 pm