Top "Ssis" questions

SSIS (Microsoft SQL Server Integration Services) is a platform for building enterprise-level data integration and data transformations solutions.

SSIS cannot convert because a potential loss of data

I have an SSIS package that imports from an Excel doc to a Database table. I am getting the following …

ssis
AcquireConnection method call to the connection manager <Excel Connection Manager> failed with error code 0xC0202009

I have an SSIS package which reads an Excel File (Data Flow Source) and transfer the data to SQL Server …

sql-server excel ssis oledb
Temporarily disable all foreign key constraints

I am running an SSIS package which will replace data for a few tables from FlatFiles to existing tables in …

sql-server sql-server-2008 ssis constraints
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server …

sql-server sql-server-2008 ssis etl
Text was truncated or one or more characters had no match in the target code page When importing from Excel file

I have an excel file with four text columns: one of them is called ShortDescription which has the longest value. …

sql-server-2008 excel ssis codepages import-from-excel
How do you call a Stored Procedure in SSIS?

I am trying to create an SSIS package that queries data from a table, and calls a stored procedure in …

sql-server sql-server-2005 stored-procedures ssis parameters
How to create an SQL table and and populate it with Excel spreadsheet data?

Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some …

sql-server excel ssis dts
How to convert blank into null in ssis

I am extracting data from excel in ssis. One of the excel column contain blank values. so i need to …

sql-server error-handling ssis
DTS_E_OLEDBERROR. Error code: 0x80004005.Difference between SQl Native client and oledb provider for sql server

There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component. …

sql-server oledb ssis dts
SSIS - the value cannot be converted because of a potential loss of data

I am relatively new to SSIS. I am trying to extract information from an Oracle database using Microsoft OLEDB for …

sql-server oracle ssis etl