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 fi…

  tush002sunny

  3 replies

  5 years, 9 months 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

  5 years, 10 months 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

  5 years, 11 months 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

  6 years 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

  6 years 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

  6 years ago

  By: MicahNikkel

• 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

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

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

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

  6 years, 2 months 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

  6 years, 2 months 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…

  TangoVictor

  15 replies

  6 years, 2 months ago

  By: TangoVictor

• 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 at…

  Nomvula

  2 replies

  6 years, 2 months 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

  6 years, 2 months 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

  6 years, 2 months ago

  By: dopydb