Top "Ssis" questions

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

How to load an XML file into a database using an SSIS package?

I am using SSIS in Visual Studio 2008. I have many XML files that I need to process and place into …

sql-server ssis business-intelligence
"Runtime error Exception has been thrown by the target of an invocation" from Script task

I have a SSIS package with a script task, I get the following error when i try to run it …

c# ssis script-task
SSIS SQL Task - "Parameter name is unrecognized"

I have a SQL Task that needs to run a simple update to update a single row. I have set …

ssis
convert Excel Date Serial Number to Regular Date

I got a column called DateOfBirth in my csv file with Excel Date Serial Number Date Example: 36464 37104 35412 When i formatted …

sql sql-server tsql ssis etl
How to transfer data using SSIS when database columns are defined as VARCHAR(MAX)?

I am getting the below message while executing a package. Text was truncated or one or more characters had no …

ssis
How do I create a step in my SQL Server Agent Job which will run my SSIS package?

I'm trying to create an automated job for the SQL Server Agent to run. The job is supposed to run …

sql sql-server database tsql ssis
Add SSIS to existing SQL Server instance

I am trying to add Integration Services an existing SQL Server 2008 instance. I went to the SQL Server Installation Center …

sql sql-server ssis installation program-files
Parameterized OLEDB source query

I am creating an ETL in SSIS in which I which I want my data source to be a restricted …

ssis bids
The job failed. The job was invoked by user<user>. The last step to run was step1

I have created SSIS package which is running successfully and dumping the data to the required place. But the same …

sql ssis job-scheduling sql-agent-job
How to avoid SSIS FTP task from failing when there are no files to download?

I'm using SQL Server 2005, and creating ftp tasks within SSIS. Sometimes there will be files to ftp over, sometimes not. …

sql-server ssis ftp