Integration Services

• Topics

  Started by

  Posts

  Last post

• Script to Get File path from a connection manager

  Hi all - I'm very green in SSIS but I've been thrown into a major project and tasked with putting i…

  Uripedes Pants

  3 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• Query Efficiency with left outer join and temp table

  Hi, We are writing a query to extract the data from oledb source(sql server) in the Data flow task.…

  ssisnovice

  4 replies

  13 years, 7 months ago

  By: ssisnovice

• ssis error "cannot detach from one or more processes"

  Hello, i have a package which runs for about 6 hours. I looked at it every once in a while, it was …

  Mikalina

  7 replies

  13 years, 7 months ago

  By: Koen Verbeeck

• SSIS skips random rows from an Excel file

  Greetings - I've got an issue to which I've not found any directly applicable information thus far…

  charris1119

  10 replies

  13 years, 7 months ago

  By: Eric M Russell

• testing return value from stored proc

  If I have a stored procedure that returns 0 on success, can I fail if it's not 0? Right now the sq…

  Matthew Cushing

  2 replies

  13 years, 7 months ago

  By: Matthew Cushing

• optimize full extract

  How can one optimize the full extraction from SAP system? I am doing a full (select *) extraction f…

  gravitysucks

  9 replies

  13 years, 7 months ago

  By: sam.dahl

• Upgrading Packages from 2005 to 2008

  Hello All I need to upgrade the ssis packages from 2005 to 2008. I am not using any package configu…

  Sachin4all

  1 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• Right justify numeric columns

  i need to right justify numeric columns before writing it to the flat file. Can anybody help? thanks

  Gerbera

  1 replies

  13 years, 7 months ago

  By: Michael Valentine Jones

• SSIS - external table is not in the expected format

  I have a daily "excel" file that I need to import into SQL server. When I open the excel file it's…

  jbrannon

  2 replies

  13 years, 7 months ago

  By: darth_vodka

• Configuration Tables not passing values to package

  So the title pretty much says it all. I developed a package on our dev server, gave the DBA what he…

  randyblackwell

  2 replies

  13 years, 7 months ago

  By: randyblackwell

• Error Passing parameters in an OLE DB Source

  I have the following statement which has a parameter SELECT CustomerID ,TerritoryID ,AccountNumbe…

  Welsh Corgi

  7 replies

  13 years, 7 months ago

  By: Welsh Corgi

• Rowcount Task

  I found an excellent example of logging in SSIS. Unfortunately I could not find the correct version…

  Welsh Corgi

  1 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• How to create connection manager for a HTML file ?

  I have been sent what I thought was excel files to import into our system with a SSIS package but a…

  mark_copley

  5 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• How to store a sqldatareader returned from from script code to database table?

  In Database1 on server A, I have a tableA with CustomerIDs. null name, null address In Database2 on…

  MissyDaisy

  6 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• assigning variable to connection manager

  Hello all, i want to know how do i use connection manager dynamically (flatfile, excel, …

  vsql

  9 replies

  13 years, 7 months ago

  By: Orlando Colamatteo