SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Count number of records in CSV fil, compare it with count in file header using SSIS 2012.

  Hi, I'm stuck with the thing where I don't know what to use for reading count in header of .csv fil…

  tush002sunny

  3 replies

  14 hours, 15 minutes ago

  By: REDDY2244

• Problem with Importing flat files with embedded (CR)(LF) characters.

  Could someone assist I have a package which imports data from a flat file the connection manager ha…

  kingdonshel

  17 replies

  2 weeks, 6 days ago

  By: gregdavis11009

• Manipulating SSIS variables in script task

  I have a SSIS package with a script task which I would like to calculate the sum of two int32 varia…

  jo_square

  7 replies

  1 month, 2 weeks ago

  By: emna

• Schedule SSIS package containing Execute Process Task for PSFTP

  I need help. I know that there have already been several forum posts about scheduling SSIS packages…

  felixhchan

  21 replies

  2 months, 1 week ago

  By: coool_sweet

• Passing a variable from ExecuteSQL task to Oracle OLE DB Source

  I have created a Package ExtractDistributionRecords. In the Control Flow, I have an Execute SQL tas…

  Debi Olk

  1 replies

  2 months, 2 weeks ago

  By: caro0901

• Check if file exists in a FTP folder

  I have a working package that gets some XML files out of a FTP folder, pulls them down local, proce…

  Putts

  11 replies

  2 months, 3 weeks ago

  By: MicahNikkel

• Importing CSV Flat File defaults all columns to 50 chars

  I have to import a CSV file into a table that has 75 columns. The Flat File connection defaults all…

  rschaeferhig

  14 replies

  3 months ago

  By: tripleAxe

• What are the alternatives to CDC for capturing and identifying the delta for a warehouse extraction?

  Hi, I'm putting together a spec for a warehouse that extracts data from 12+ sites. I've told them t…

  davepc

  9 replies

  3 months, 1 week ago

  By: vijay

• Does SSIS not handle the SQL variant type on transfer?

  Hi, I have to get records of one table which is in different server to another table of another ser…

  md.noorullah

  9 replies

  3 months, 1 week ago

  By: Phil Parkin

• SSIS Import of XML - XML Source problems

  Hi Guys, Was wondering if anyone can give me a little insight into a problem I've been having when …

  IanThomas

  4 replies

  3 months, 4 weeks ago

  By: Achilies

• Ideas on resolving error -- "VS_NEEDSNEWMETADATA".

  Hi I am running a large dtsx package and in a data flow task I am getting the following error in th…

  Mark F-428640

  19 replies

  4 months, 1 week ago

  By: kgomescabral

• SSIS script task

  hi i want to pass an object variable to a string variable so that i can use the string variable to …

  dopydb

  0 replies

  4 months, 1 week ago

  By: dopydb

• is there a way to do a mass update in SSIS

  Without using a stored procedure is there a way to do a mass update in SSIS? Currently using the OL…

  AlphaTangoWhiskey

  15 replies

  4 months, 1 week ago

  By: AlphaTangoWhiskey

• Split file attachment if they exceed size limit

  Hi I’ve developed a package where I loop through files from a specific path and send them as an …

  Nomvula

  2 replies

  4 months, 2 weeks ago

  By: Nomvula

• Foreach Loop Container Missing in my Toolbox

  There is no Foreach Loop Container available in my toolbox, am I missing a patch of some sort? Has…

  Gator-488553

  3 replies

  4 months, 2 weeks ago

  By: simsterman