SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Do not know how to deploy package from Dev Server to Prod Server

  Hi, I hope someone could guide me on this.I have tried many many attempts for the past few days and…

  Lookup_BI

  18 replies

  13 years, 5 months ago

  By: Koen Verbeeck

• Using SSIS to read from MySQL

  I was attempting to use SSIS to use MySQL as a data source. I originally had created the package i…

  kevlray

  10 replies

  13 years, 5 months ago

  By: aniket2662

• Error starting debugging. (Microsoft.DataTransformationServices.VsIntegration)

  Howdy Anyone have any idea what this is? Error starting debugging. (Microsoft.DataTransformationSer…

  d_george

  13 replies

  13 years, 5 months ago

  By: Welsh Corgi

• DTEXEC thorws error saying Argument "Excel" for option "connection" is not valid.

  I have developed a SSIS package this runs fine in BIDS and even when i run through DTEXEC UI but wh…

  nogardoel

  12 replies

  13 years, 5 months ago

  By: devraj.meher

• business key in Scd

  i have two tables one in staging and one in destination .both are identical and both have identity…

  weston_086

  1 replies

  13 years, 6 months ago

  By: Sean Lange

• Missing Records with SSIS

  Hi, I am getting an issue frequently. I have a SQL statement which inserts huge data into a table u…

  Ram:)

  5 replies

  13 years, 6 months ago

  By: HowardW

• Ayuda al cargar un CSV con tipo de dato Numeric(15,3)

  Hola Foro; estoy pasando un archivo CSV a una tabla de Oracle: Archivo csv : xxxxx,10.70,0.89 Tab…

  samuel san miguel

  4 replies

  13 years, 6 months ago

  By: Steve Thompson-454462

• Error Message and Failure Rows for SSIS Logging

  I have an question to the old SSIS Logging Theme. We want to log (for example): - ErrorMessage - Er…

  Henrik Schütze

  3 replies

  13 years, 6 months ago

  By: Koen Verbeeck

• Need Help Pulling Data from an Oracle Database

  Can someone tell me how I can use SSIS to connect to and extract data from an Oracle database usain…

  gregory.perry2

  2 replies

  13 years, 6 months ago

  By: Sir Hossfly

• using ; (semi colon) within DTEXEC parameter value?

  Dear all, I am trying to start a SSIS Package via DTEXEC and pass a database connection through a p…

  Eric Mamet

  4 replies

  13 years, 6 months ago

  By: nospams

• Precedence constrain expression not working when I compare two package variables

  I've two tasks, lets says TaskA and TaskB. Also i've two more package user variables lets say VarA …

  sql server developer

  1 replies

  13 years, 6 months ago

  By: sql server developer

• How to update a table data based on data from a different database server using SSIS package

  Hi I need help with SSIS in sql server 2005. How can I update rows in a table based on data selecte…

  sellonster

  6 replies

  13 years, 6 months ago

  By: Phil Parkin

• Logging DTEXEC to a table

  Hello All, Can I log the results of DTEXEC to a local table? When I run it from SSMS the results ar…

  Chrissy321

  6 replies

  13 years, 6 months ago

  By: Orlando Colamatteo

• Multiple Result Sets to a Flat File?

  Hi Guys, I have a procedure which will return two result sets. 1==> SELECT EmpID FROM …

  sqlusers

  8 replies

  13 years, 6 months ago

  By: sqlusers

• SSIS flat file varchar to Date type issue.

  Hi Everybody, My source is flat file has column1 which is string type and values are like "12/21/2…

  sunnyepgc

  3 replies

  13 years, 6 months ago

  By: Koen Verbeeck