Integration Services

• Topics

  Started by

  Posts

  Last post

• Redirect duplicate records using ssis

  Hi, We have a requirement like the source is excel and there are duplicates in the file we need to…

  nhimabindhu

  8 replies

  11 years, 1 months ago

  By: stevefromOZ

• SSIS 2012 pull from DB2

  hi I'm stuck in driver hell I want to pull data from DB2 into SQL server using SSIS 2012 (Windows 7…

  darth_vodka

  3 replies

  11 years, 1 months ago

  By: Alex Galisteo

• SSIS puzzle

  Hey guys I thought this might interest SSIS developers here: Problem statement: I have two servers …

  DataEnthusiast

  2 replies

  11 years, 1 months ago

  By: stevefromOZ

• SSIS won't let me change the database

  I have a package with two connection managers (ADO and OLE) pointing to a deprecated database. So,…

  cafescott

  3 replies

  11 years, 1 months ago

  By: Jack Corbett

• IS Package running C# Script logging file name is csv file. Works fine is ISSIS but doesnt log all files when set up as an overnight job

  Hi there, Im just in the middle of testing this issue but I wondered if anyone else had seen anythi…

  Debbie Edwards

  4 replies

  11 years, 1 months ago

  By: Debbie Edwards

• Package Parameters Issue

  Hi I have started giving Project parameters a try in SSIS 2012 in order to pass through values from…

  rcr69er

  3 replies

  11 years, 1 months ago

  By: rcr69er

• SSIS to load different format of excel file to SQL table

  Hello I am new to SSIS. I would like to find a way to load 3 different excel file to 3 different SQ…

  Stanley Pagenel

  7 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• Capture Transformation error

  Hi to all, I have a data flow task with one source and one destination. Between source and destina…

  previn1980

  2 replies

  11 years, 1 months ago

  By: Ells

• Issue while runing the SSIS package pkg.Execute

  I am executing the PKG using the below code Console.WriteLine("Package Execution Started"); …

  rajarajansudar

  1 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• dynamically add the columns in excel using ssis

  Hi, I have given to create a ssis package where i have list of columns mapped from excel to sql de…

  scuby.me

  1 replies

  11 years, 1 months ago

  By: Ells

• SSIS 2005 Interview Questions

  Hi All, Please provide me a link from where I can download the SSIS/SSAS/SSRS 2005 interview questi…

  ashish.mehrotra

  7 replies

  11 years, 1 months ago

  By: Stuart Davies

• Sql 2012 Ssis row by row processing

  I am converting data from one db to another and one of the main tables is a master name tables. The…

  teareal_1

  4 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• Flat file read , conditionally extract data rows

  This is urgent please. Use SSIS flat file sample content (use attachement, sampleFF), ABC 8585 …

  daniarchitect

  5 replies

  11 years, 1 months ago

  By: Eirikur Eiriksson

• copy table with data from one server to other

  Hi all, I am having SP which gives dynamic resultset. i.e.number of columns varies from min 5 to m…

  abhas

  1 replies

  11 years, 1 months ago

  By: g.britton

• Getting Error while executing SSIS package - need quick help

  Hi All, While executing one of package in PROD environment we are getting below error. component "…

  rhythmk

  8 replies

  11 years, 2 months ago

  By: MMartin1