1. cplimmy New Member

   Hi All,
   OS: Windows 2003 R2
   SQL version: MSSQL2005 SP4
   When using SQL server Import and export wizard to do importing data from csv flat file to table. It hits errors at "Initializing Data Flow Task (error)" screen and stop the process.
   I have checked the windows event log, it shows event id 12291 SQLISPackage failed.
   How do fix this errors?
   regards,
   CP
   

   cplimmy, Mar 27, 2011

   #2
2. satya Moderator

   Did you check whether the columns defined in table and data from source file matches.
   The best bet is to enable logging for the package, see http://msdn.microsoft.com/en-us/library/ms138020.aspx and http://sqlserver-qa.net/blogs/tools...ging-providers-make-best-use-of-ssis-too.aspx fyi.
   

   satya, Mar 31, 2011

   #3
3. satya Moderator

   Did you check whether the columns defined in table and data from source file matches.
   The best bet is to enable logging for the package, see http://msdn.microsoft.com/en-us/library/ms138020.aspx and http://sqlserver-qa.net/blogs/tools...ging-providers-make-best-use-of-ssis-too.aspx fyi.
   

   satya, Mar 31, 2011

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in