Top "Ssis" questions

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

How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken …

sql ssis
SSIS Convert Between Unicode and Non-Unicode Error

I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except …

unicode ssis non-unicode
What is the SSIS package and what does it do?

Can someone tell me what the SSIS package is all about? I am totally new to data-warehousing and I am …

ssis
Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type

I have made a dtsx package on my computer using SQL Server 2008. It imports data from a semicolon delimited csv …

sql-server-2005 unicode ssis types non-unicode
How do I view the SSIS packages in SQL Server Management Studio?

Argh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server …

sql-server-2005 ssis ssms
'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS …

sql-server excel ssis oledb aceoledb
Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me …

sql sql-server tsql ssis
How do I edit SSIS package files?

I have a DTSX file in a project I'm taking over. I have Visual Studio 2005 Pro, but it just opens …

ssis
How do I fix the multiple-step OLE DB operation errors in SSIS?

I'm attempting to make a DTS package to transfer data between two databases on the same server and I'm getting …

sql-server ssis
SSIS how to set connection string dynamically from a config file

I am using SQL Server Integration Services (SSIS) in SQL Server Business Intelligent Development Studio. I need to do a …

ssis connection-string configuration-files