August 30, 2010 at 3:24 am
Hi Folks,
I am having problems using the Import Wizard on a flat file. The task should be quite straight forward: I have a file myTable.txt and I am trying to import it into the table with the same name and structure that already exists in the target database.
The Wizard correctly finds the target table but doesn't correctly match up the SSIS data types with the data types that are actually in the target table. For example the wizard will use a SSIS 'string' data type for a column in my file that is going to end up in a column with data type 'time' in my table. The import then fails.
Where am I going wrong?
I could manually change the datatype but I have a lot of files to import in this way and I figure that if the wizard knows what fields the data is going into (and what types these fields are) then it should be able to assign the correct SSIS datatypes on the fly
Many thanks in advance,
Chris
September 2, 2010 at 9:38 am
have you considered using bcp to insert your data with a format file?
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
September 3, 2010 at 2:00 am
Thank you, I'll give it a try
Chris
September 3, 2010 at 7:01 am
best of luck - if you need help, be sure to post and i'm certain someone can help with the syntax etc.
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply