SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Create Header and detail in SSIS

  Hello guys , There is any other way to create Header and headers detail in one file ? Except This: …

  3935

  2 replies

  12 years, 12 months ago

  By: Phil Parkin

• Some Excel rows not importing to SQL Server

  I've been searching and found some similar issues but nothing exactly like this. I had a simple SSI…

  crazy.fingers.16

  3 replies

  13 years ago

  By: crazy.fingers.16

• interactive package in SSIS?

  Hi! Is there a simple way to design an interactive package in SSIS? I am not too enthusiastic about…

  public2 61705

  36 replies

  13 years ago

  By: herladygeekedness

• OLE DB Staging Table to OLE DB Destination Table, data type problem

  I'm successfully moving all columns from staging to destination table, with one caveat. The column…

  KoldCoffee

  13 replies

  13 years ago

  By: Charmer

• Writing the Execute SQL Task Output to package Variable

  Hi All, I'm using "Execute SQL Task" for the query "SELECT Count(*) FROM Table A". On the resultse…

  Turtle2008

  14 replies

  13 years ago

  By: marcusq71

• Unique constraint disappears after package restart

  Hi, We have one package where we am inserting into a OLEDB destination. Often we get an error that …

  Ally Abbas

  7 replies

  13 years ago

  By: Ally Abbas

• SSIS data source from multiple-dataset stored procedure

  hi if I have a stored procedure that returns multiple datasets, like create PROCEDURE [dbo].[zz_Tes…

  darth_vodka

  2 replies

  13 years ago

  By: Phil Parkin

• Delete Remote Files With FTP Task

  I have a sequence with two FTP Tasks; one to retrieve a file from an FTP server, the other to delet…

  Tim Riley-437154

  7 replies

  13 years ago

  By: cshantanu

• variable problem

  I have been trying this all day but don’t seem to get to work. What I am trying to do is to capture…

  gravitysucks

  1 replies

  13 years ago

  By: Koen Verbeeck

• Integration job failing....

  Hi, One of the job integration job was failed today. It was scheduled every day. And I found the er…

  mohan.bndr

  2 replies

  13 years ago

  By: herladygeekedness

• Invalid length parameter passed to the LEFT or SUBSTRING function.

  declare @AsOfDate DATETIME = '2012-06-20 00:00:00.000' DECLARE @CSV NVARCHAR(4000) = '' D…

  ashuthinks

  2 replies

  13 years ago

  By: Sean Lange

• query optimization

  can anyone give me the techniques for optimizing query and procedures.

  shubhamagrawal.107

  1 replies

  13 years ago

  By: BrainDonor

• Send Mail Error

  Hi guys, I'm getting the following error when running scheduled SQL Agent job - Microsoft (R) SQL…

  dmoss 21092

  2 replies

  13 years ago

  By: dmoss 21092

• Transaction handling in SSIS

  I have 4 Data Flow Tasks in my package. First DFT has a no. of OLE DB Source and Destinations. Rest…

  anjali.vishwakarma

  2 replies

  13 years ago

  By: moni_achanta

• Foreach iteration delay

  Hi, I have an SSIS package that produces around 20 files. Each of these has to be moved to somewhe…

  CraigIW

  2 replies

  13 years ago

  By: Phil Parkin