Viewing 9 posts - 1 through 9 (of 9 total)
The 32-bit dtexec gives the same errors in Production.
Given that there are no errors in QA with the same make/model of hardware, I'm asking our Windows admins to look at...
April 3, 2012 at 11:20 am
It's executing now.
It's writing buffer files to the designated location. A total of 27 files, about 650MB thus far (free space is nearly 1 TB on the disk). It's chewing...
April 3, 2012 at 8:48 am
Your requirement is logically inconsistent. The two rows you say you want to exclude do, in fact, meet the criteria that you gave at the beginning, which is that CompanyA...
April 3, 2012 at 8:37 am
opc.three (4/2/2012)
April 3, 2012 at 8:08 am
It used to be you would restore everything from the same backup set in case there was activity in the user databases that would put them out of synch with...
May 17, 2011 at 7:47 am
I've never tried this but supposedly you can add "IMEX=1; MAXROWSTOSCAN=0" to your Excel connection string to force SSIS to reconsider what the data type should be. I don't know...
June 17, 2010 at 12:44 pm
There are three places to change the data type. You did output and error, you also need to do input. Same place, different part of the tree.
June 17, 2010 at 11:04 am
😀 I just hope it works, I did that from memory.
June 17, 2010 at 10:14 am
You should be able to tell the Excel Data Source to treat the Address1 field as a text stream rather than as a string. Right-click on it and pick "Advanced...
June 17, 2010 at 9:58 am
Viewing 9 posts - 1 through 9 (of 9 total)