SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS- Get count of the oracle tables in SSIS

  In SSIS , I need to check if a source oracle table has any rows if there are rows I need to proceed…

  laxmikantareddys

  1 replies

  13 years, 9 months ago

  By: Phil Parkin

• Error at Data Flow Task [Flat File Destination [4165]]: The data type for "input column "Reason" (5098)" is DT_NTEXT, which is not supported with ANSI files

  Hi All, I'm hoping to get help from here. I'm trying to load some data from Sharepoint list to…

  Patrick.I

  2 replies

  13 years, 9 months ago

  By: Patrick.I

• How to convert one column to many - table to Excel

  I have a table with one varchar(1000) column of pipe delimited data. The contents are exported to …

  Randy Doub

  2 replies

  13 years, 9 months ago

  By: Randy Doub

• how to load dynamic values into a conditional split

  i have a 500 row table that i need to periodically dump to csv or excel format. the only gotcha is …

  alen teplitsky

  1 replies

  13 years, 9 months ago

  By: drew.allen

• Converting Varchar to smallint

  I am trying to convert Varchar(5) to smallint, I tried in both Derived Column transformation and Da…

  kishoremania

  3 replies

  13 years, 9 months ago

  By: gmuchan

• Updating parent variables from a child package

  I'm getting a child package to see the parent packages variables correctly, but I now want the chil…

  vince.iacoboni@db.com

  8 replies

  13 years, 9 months ago

  By: SQLSandwiches

• Loading an 2003 excel sheet using SSIS and running from agent job

  Hi, I have a very critical issue that we are facing on our 64-bit server. Environment Details: Oper…

  John Reddy

  3 replies

  13 years, 9 months ago

  By: John Reddy

• Data Flow Task - Have Null values take table default

  Hi, I have a data transform from a flat-file to a SQL server database. Some of the flat-file field…

  Jeffrey Pasqua

  3 replies

  13 years, 9 months ago

  By: david.blythner

• need help with regex excluding .txt extension in for each loop

  I have 2 files named charge_t, the only difference is that one has a .txt extension and the other h…

  dndaughtery

  4 replies

  13 years, 9 months ago

  By: dndaughtery

• close connection manager?

  Hi all, Have a bit of a tricky situation to deal with. I have a package, which, at the end of its e…

  kramaswamy

  4 replies

  13 years, 9 months ago

  By: Elliott Whitlow

• Column Mapping Improvements in Denali

  Very nice - see this link for info.

  Phil Parkin

  2 replies

  13 years, 9 months ago

  By: Elliott Whitlow

• Orcale Sp output parameter to excute sql task parameter mapping

  I have a orcale sp, where an output parameter (which is a Number Datatype) is set on execution, nee…

  quillis131

  4 replies

  13 years, 9 months ago

  By: quillis131

• Appending to CSV file

  I have 3 data flows that need to write to the same csv file. The problem thats occurring right now …

  dgostrer

  2 replies

  13 years, 9 months ago

  By: dgostrer

• SSIS: Select Query on multiple databases.

  Hi, I am new in SSIS and seeking help to fatch data from tables on multiple DB's. I want to do this…

  atulsvastava-816549

  5 replies

  13 years, 9 months ago

  By: kramaswamy

• Control Flow tasks

  Can anyone suggest me a link where I can find details & functions of all the tasks in control …

  Royal PS

  4 replies

  13 years, 9 months ago

  By: Royal PS