SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• 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 weeks, 1 day 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

  3 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

  3 weeks, 5 days 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

  1 month 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

  1 month, 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

  1 month, 2 weeks ago

  By: Phil Parkin

• SSIS forum

  Hello all, This is a pretty dead forum at the moment so I hope that someone is reading this. I am h…

  Jamie Thomson

  12 replies

  1 month, 4 weeks ago

  By: Anjali Verma

• 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

  2 months 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

  2 months, 2 weeks 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

  2 months, 2 weeks 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

  2 months, 2 weeks 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

  2 months, 3 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

  2 months, 3 weeks ago

  By: simsterman

• Variable does not contain a valid data object

  hi i have an ssis package (2005) that initially executes a sql task to get some results - of which …

  dopydb

  1 replies

  2 months, 3 weeks ago

  By: dopydb

• SSIS from ODBC source using a dynamic sqlcommand

  Does anyone know how I can use a user variable in a sqlcommand in a Datareader source with an ODBC …

  jarmstrong-537702

  12 replies

  3 months ago

  By: afzaki7