SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• "Delete files older than X days" error

  Hi, I am using the script task to delete the old files(older than 10 days) present in a particular …

  marees.inspire

  3 replies

  13 years, 1 months ago

  By: gabrielko_47

• Need to call a batch file from a remote server

  Hey guys, I'm creating a SSIS package and one of the first steps is to stop services on a remote se…

  SQLBrady

  2 replies

  13 years, 1 months ago

  By: Phil Parkin

• Error : Opening a rowset for "Sheet$" failed. Check that the object exists in the database.

  Hi, i am trying to load the data from excel sheet using For each loop container in ssis 2005. But i…

  sqlstud

  1 replies

  13 years, 1 months ago

  By: Phil Parkin

• Getting Error for Dynamic file name

  Hey I am also working on same task like this In SSIS ftp task... Here I created a variable for gett…

  murali.ms18

  2 replies

  13 years, 1 months ago

  By: Phil Parkin

• SSIS Flat File Import - CSV Files with empty information

  Hi All, Hopefully I can get a bit of help on the below. Firstly a bit of background I have a SSIS p…

  Tava

  4 replies

  13 years, 1 months ago

  By: Tava

• Matched and Unmatched Rows in ssis 2005

  Hi, Need to transfer data from database Db1 (Db1.sampletab1) to database Db2 (Db2.sampletab2) using…

  sqlstud

  3 replies

  13 years, 1 months ago

  By: sqlusers

• How to insert records based on Audit Table

  Audit table: CREATE TABLE [dbo].[AUDIT_RECORD]( [FILENAME] [varchar](100) NULL, [LOAD_DATE] [date…

  sqlstud

  3 replies

  13 years, 1 months ago

  By: sqlstud

• SSIS Import/Export Failed. Duplicate Key even w/ "Delete Rows" Checked

  Running SQL 2005 SP4 I am trying to use the Import/Export Wizard to copy 40 table from Server A to …

  homebrew01

  1 replies

  13 years, 1 months ago

  By: Koen Verbeeck

• stored procedure process with ssis

  this post is really meant for ssis 2008 but there is no ssis 2008 spot, just a 2005. 🙁 so pleas for…

  wnarretto

  3 replies

  13 years, 1 months ago

  By: wnarretto

• Merge Join transformation failing - Destination Column does not allow NULLS

  Hi, I am using a MERGE JOIN SSIS transformation to join the results of 2 queries, which already con…

  steve.burton 78514

  1 replies

  13 years, 1 months ago

  By: herladygeekedness

• Check if File Exists?

  Hi Firends, I have a folder containing 30 text files(each file is different in s…

  Charmer

  7 replies

  13 years, 1 months ago

  By: Phil Parkin

• SSIS Secure FTP Task

  I am needing to transfer data using an encrypted tunnel. The only way I know of how to do this is t…

  Ben Sullins-437405

  46 replies

  13 years, 1 months ago

  By: it 360

• imoprt XML Data from xml file having more than 15000 charecter row to sql server destination using ssis

  In my Xml file one column having more than 15000 thousand charecter row, but in xml source read onl…

  DBA.k

  1 replies

  13 years, 1 months ago

  By: COZYROC

• Using the Transfer SQL Server Objects Task to copy table to a new schema in another db

  I am attempting to use a Transfer SQL Server Objects Task to copy tables, udf, stored procs, and vi…

  dndaughtery

  2 replies

  13 years, 1 months ago

  By: dndaughtery

• How to find packages which include a specific database as a datasource

  Problem : Database needs to move from one server to another. Before moving the database, I would ne…

  MadAdmin

  2 replies

  13 years, 1 months ago

  By: MadAdmin