Top "Ssis" questions

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

"Unable to read data from the transport connection: net_io_connectionclosed." - Windows Vista Business and SMTP

Unable to test sending email from .NET code in Windows Vista Business. I am writing code which I will migrate …

c# .net windows-vista ssis system.net.mail
How to empty my destination table before inserting new records in SSIS?

I use SSIS to generate and transform new data for later use in a new system. I have a problem …

sql-server database ssis relational-database
How to make an HTTP request from SSIS?

I'm interested in knowing how I can make an HTTP call from SSIS. For example, I would like to be …

http ssis
What are the differences between Merge Join and Lookup transformations in SSIS?

Hi I'm new to SSIS packages and writing a package and reading up about them at the same time. I …

sql-server ssis
SQL Server 2012 Integration Services failed when connecting thru SSMS

I had recently installed SQL server 2012 and I used mostly the default settings. Database works fine and I can happily …

sql-server ssis
How to import a fixed width flat file into database using SSIS?

Does any one have a tutorial on how to import a fixed width flat file into a database using an …

ssis flat-file
SSIS Control Flow vs Data Flow

I don't entirely understand the purpose of control flow in an SSIS package. In all of the packages I've created, …

ssis control-flow
SSIS Script task to check if file exists in folder or not

I want to check to see if a file exists in a particular folder from SSIS. How can I accomplish …

c# file ssis file-exists
SSIS How to get part of a string by separator

I need an SSIS expression to get the left part of a string before the separator, and then put the …

sql-server ssis expression etl
Connect to SQL database inside Script Task in SSIS

Inside of a Script Task in SSIS, I need to make a call to an SQL database. I have a …

c# sql sql-server ssis script-task