SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Use xm_cmdshell to execute a SSIS package and pass a variable

  the following code produces error 'C:\program' is not recognized as an internal or external command…

  mz1derful

  5 replies

  15 years, 5 months ago

  By: mz1derful

• DATALENGTH

  I have a staging table with different number of records each time loaded. But the datalength of th…

  PSB

  4 replies

  15 years, 5 months ago

  By: Phil Parkin

• CSV import fail when set as sql job

  Hi I have a csv file on a fileserver. I need to import this into a table in one of our sql 2005 ser…

  @DJ

  6 replies

  15 years, 5 months ago

  By: Phil Parkin

• Error in query in SSIS

  Hello, I am trying to add the below query in the dataflow task(oledb source): select BL_ID, BL_NUM,…

  pwalter83

  8 replies

  15 years, 5 months ago

  By: pwalter83

• Flat file to Excel destination!

  I ahve a flat file and I need to import the file to Excel. In the flat file there are a bunch of un…

  PSB

  2 replies

  15 years, 5 months ago

  By: Phil Parkin

• ErrorCode + ErrorColumn Information

  Hello guys, i've read this forum and also other SQL Server 2005 Integration Services forums and th…

  n3bunaticu

  4 replies

  15 years, 5 months ago

  By: vguruprasad_kpm

• Need to Migrate SSIS 2005 Packages into SSIS 2008

  Hi experts, I need to know , how to migrate the ssis2005 packages into SSIS 2008. Difference betw…

  brainblower13

  4 replies

  15 years, 5 months ago

  By: lduvall

• SSIS get hour from date

  I have a filename of the format T2011012412ABC Where 2011= year 01=Month 24=Date 12=hour I am using…

  PSB

  5 replies

  15 years, 5 months ago

  By: PSB

• Check files If exists or if not exists

  Hi all , I have to check for files are exists or not,I have a table which contains filenames and i …

  guru12

  8 replies

  15 years, 5 months ago

  By: Phil Parkin

• Mailbox unavailable!

  Since last week package runs as expected in our production server. From yesterday, for a particular…

  sqlusers

  2 replies

  15 years, 5 months ago

  By: Elliott Whitlow

• Checking for File Existence in File Share - If not exists, check for another file

  I have read about using script task to check the existence of a file in a directory or a file share…

  kirank5

  3 replies

  15 years, 5 months ago

  By: steveb.

• SSIS SQL Task - Valid Oracle Code Fails in SQL Task

  I'm attempting to automate the creation of partitions in a Business Intelligence Dev Studio project…

  kellerb

  6 replies

  15 years, 5 months ago

  By: Evil Kraig F

• SSIS CSV failure to import

  Hi, I have a CSV file which has been generated from an Excel Spreadsheet. I have various problems i…

  wood.kieran

  13 replies

  15 years, 5 months ago

  By: aimtwo

• SSIS update table with date variable

  SSIS is new to me, and version is 2005. Have a flat file dumped into a sql table. After this record…

  certuser76

  2 replies

  15 years, 5 months ago

  By: certuser76

• please help very urgent

  Hello All, Yesterday my new boss gave me this assignment on SSIS , I am hoping some one of you migh…

  BoobyB

  11 replies

  15 years, 5 months ago

  By: vasanth-257691