Integration Services

• Topics

  Started by

  Posts

  Last post

• ssis package

  how to create SSIS packages and how to change the connection string .

  bushraali_2005

  1 replies

  10 years, 5 months ago

  By: Elliott Whitlow

• How to Redirect Invalid Rows From Flat File with line number and error column name

  Hi, In my package source is flat file, now I want to redirect bad rows to error output with the lin…

  vipin_jha123

  4 replies

  10 years, 5 months ago

  By: Phil Parkin

• Excel Source - Overide External Columns Datatype

  HI All, I'm having a problem with an ETL project I'm working on. The file I receive has multiple sh…

  Thom A

  6 replies

  10 years, 5 months ago

  By: Thom A

• How write if condition in the derived with appending string

  i need to write condtion like this if ( System ID =="RE2") { Account_num +"-"+ coulum } i wro…

  rajarajansudar

  1 replies

  10 years, 5 months ago

  By: Phil Parkin

• Data Type checks in SSIS Package

  Hi , I have to perform several data cheks before loading data into target table. Foe example I am h…

  vipin_jha123

  1 replies

  10 years, 5 months ago

  By: John Mitchell-245523

• can not edit connection manager server name to a new value.

  I am having trouble changing the properties on a connection manager, specifically the server name. …

  PearlJammer1

  6 replies

  10 years, 5 months ago

  By: PearlJammer1

• SSIS Moving Flat files

  I have a folder with 6 files with name format as 2201.txt, 2202.txt.....2206.txt. When we open the…

  pasumarthi.akash

  2 replies

  10 years, 5 months ago

  By: pasumarthi.akash

• How do I run multiple data flow tasks in parallel within the same transaction?

  I have a package with 3 parallel data flow tasks added in a sequence container. I need to implement…

  dudekula.kareemulla

  3 replies

  10 years, 5 months ago

  By: Phil Parkin

• Impact on Sharepoint databases if updating from SSIS

  Hello I would like to know your views regarding updating Sharepoint data in lists/libraries using S…

  fiyo

  4 replies

  10 years, 5 months ago

  By: fiyo

• Using SSIS to refresh database before go live

  We are migrating our vendor's app and would like to move all the data from the custom tables over t…

  dwilliscp

  8 replies

  10 years, 5 months ago

  By: John Rowan

• how import *.db and *.px files in SSIS to SQL data bases?

  Hi everyone, i'm new in this page and have a question. how import *.db and *.px files in SSIS to SQ…

  dramon14

  3 replies

  10 years, 5 months ago

  By: John Rowan

• How to get previous/current task name in the script task

  Guys i am building the custom logging framework in that i want get the task name ( Eg: get the dat…

  rajarajansudar

  4 replies

  10 years, 5 months ago

  By: rajarajansudar

• Issues and performance of importing XML into SQL Server 2008

  I know this long, but I think my question requires a lot of background information. The simple que…

  Jason

  9 replies

  10 years, 5 months ago

  By: Alan Burstein

• Import CSV. Multiple Rows. Split order when items total 720g

  SSIS 2008 Hi there, we import orders for our clients from .csv text files that they provide us each…

  chris-1111548

  3 replies

  10 years, 5 months ago

  By: Jeff Moden

• SSIS 2012 package execution fails - create_execution timeout error 27195.

  Hi, I've just upgraded my SSIS packages from SQL2005 to SQL2012 and I'm using SQL Agent to execute …

  greenantim

  2 replies

  10 years, 5 months ago

  By: SQL ADMIN 79