When performed Import data, event ID 12291 package failed exists. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

When performed Import data, event ID 12291 package failed exists.

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

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.

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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |