SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Issues while executing the xp_cmdshell through SSIS

  Hi All - First let me tell you what my SSIS package does, SSIS Package: - As per the business requi…

  skpanuganti

  13 replies

  1 month, 2 weeks ago

  By: Jake.ONeill

• Change column order in Flat File Destination

  Hi there, I have several Flat File destinations and I need to change the output column order in eac…

  keymoo

  16 replies

  1 month, 3 weeks ago

  By: Phil Parkin

• Call SSIS package residing on DB Server from a web application ASP.NET residing on Web server

  I have a requirement where I need to call a SSIS package from a ASP.NET application. The SSIS packa…

  vishal.shinde

  14 replies

  2 months ago

  By: COZYROC

• SSIS 2016 ROW counts to a Flat File destination

  Hi, I have 3 flat file sources. Now I want to count the number of records in each flat file and I w…

  BIsweet

  6 replies

  2 months, 2 weeks ago

  By: Phil Parkin

• Error while running SQL Agent job(SSIS) after set value in Set Values tab of package

  Buddies, I created a job with five SSIS packages in SQL Server Agent->Jobs folder. If I run the …

  Kari Suresh

  14 replies

  2 months, 3 weeks ago

  By: jamestow

• SSIS 2008 - Failed to lock variable Error (Oh, I fixed it)

  I have a package in SSIS that I just created. It contains 2 ForEach loop containers. Within each co…

  Brandie Tarvin

  5 replies

  3 months, 1 week ago

  By: Phil Parkin

• Querying against Access db in SSIS

  Hi All, I'm trying to read the data in Access database using Execute SQL Task. I'm trying to…

  sql server developer

  8 replies

  3 months, 1 week ago

  By: mlinden80

• Determine user SSIS package run as

  I have an SSIS package that is failing. The SSIS package was built in Visual Studio 2005, and is ru…

  r.gall

  1 replies

  3 months, 3 weeks ago

  By: Thom A

• VS_NEEDSNEWMETADATA error

  Hi, I am trying to run an SSIS package via a job. However, I get the below error: Started: 11:18:0…

  pwalter83

  6 replies

  3 months, 3 weeks ago

  By: Subhraz

• Exporting Multiple SSIS packages from MSDB

  If we need to export a package from MSDB into the file system we can do it using the SQL Management…

  anilkumar0902

  14 replies

  4 months, 3 weeks ago

  By: Ravi Vissa

• SSIS using source of password-protected Excel Files

  I need to import data from an Excel file into a SQL 2005 DB and thought I would use SSIS since this…

  aber

  13 replies

  5 months ago

  By: lilymarthan

• 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

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

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

  7 months, 1 week ago

  By: coool_sweet