SSIS (Microsoft SQL Server Integration Services) is a platform for building enterprise-level data integration and data transformations solutions.
I right clicked on a Database in the object explorer of SQL Server 2008 Management Studio. I went to Tasks > …
sql-server-2008 ssisWhen an excel data source is used in SSIS, the data types of each individual column are derived from the …
excel ssisI have a Data Flow Task that is hanging on excecution. The flow is simple, makes two queries to different …
sql-server ssis etlI have this annoying problem where it says that the project and package have different protectionlevels. Which is not true, …
ssis sql-server-2012I have a SSIS package with a control flow containing a bunch of execute sql tasks in a sequence. I …
sql-server sql-server-2008 ssisThis is my very first time playing with SSIS in SQL Server 2012. I can successfully read an excel file and …
sql-server ssis sql-server-2012 etlI am migrating data that has to be inserted using stored procedures which already exist. The stored procedures have parameters …
sql-server stored-procedures ssis oledbcommandIf I can do the required ETL requirements using stored procedures, any advantages of using SSIS packages instead? My ETL …
sql-server ssisI have an SSIS package thats unzips and loads a text file. It has been working great from the debugger, …
sql-server ssis sql-server-2008-r2 flat-fileI have 2 scheduled jobs on my SQL Server 2005 machine that are scheduled to run each morning (around 2:00 AM). These jobs …
sql-server sql-server-2005 ssis ibm-midrange bids