Integration Services

• Topics

  Started by

  Posts

  Last post

• Cannot find Oracle Provider in the Package after migrating from 2005 to 2008R2

  Hi Guys, We are migrating from SQL SERVER 2005 to SQL SERVER 2008R2. SQL SERVER 2005 is on one serv…

  grkanth81

  7 replies

  14 years, 7 months ago

  By: Welsh Corgi

• Not able to run SSIS package in 64 bit server

  I created some SSIS packages. I am able to run these packages in BIDS without any issue. When the D…

  supjo

  23 replies

  14 years, 7 months ago

  By: Koen Verbeeck

• Reading a text file and importing to database

  Hi, I am new to SSIS have a question regarding reading text file and importing to sql server 2005 …

  Pink123

  2 replies

  14 years, 7 months ago

  By: Pink123

• Setting UserName & Password for each individual task/Component OR each connection

  .....And here is my request for help on this long description...... I have to write a SSIS pkg, wit…

  Lonely Rogue

  4 replies

  14 years, 7 months ago

  By: Lonely Rogue

• Importing CSV file into MS Access Database using Integration Services

  I need to automate the transfer of a CSV file into a MS Access database on a daily basis. Is it pos…

  jman76

  1 replies

  14 years, 7 months ago

  By: Chuck Hottle

• Rounded Derived Column Using Division

  I am creating a derived column with the following code: (DT_NUMERIC,18,3)(DER_Channel == "M" ? ((DA…

  Triality

  1 replies

  14 years, 7 months ago

  By: Triality

• Processing XML Column in SSIS

  Here's my dilemma. I have to process about 66k rows of data which contain an XML column (stored as …

  Jack Corbett

  4 replies

  14 years, 7 months ago

  By: Jack Corbett

• Removing SSIS project in BIDS

  I am trying to remove SSIS project in BIDS. When you right click on the project in solution explore…

  Smash125

  1 replies

  14 years, 7 months ago

  By: Smash125

• What is difference between For Loop, For Each Loop and Sequence containers?

  Can anybody give me the difference between For Loop, For Each Loop and Sequence containers in simpl…

  rajesh.dhanbad

  3 replies

  14 years, 7 months ago

  By: Matt Miller (4)

• Truncation warning while extracting data from oracle varchar2(20 char) to sql server varchar(20)

  Hi, We are extracting data from oracle table to sql server 2005. the data type of varchar columns i…

  ssisnovice

  2 replies

  14 years, 7 months ago

  By: ssisnovice

• Conversion while extracting

  [font="Tahoma"] Hello Friends, I am new to SSIS. I am trying to create an extract by joining few ta…

  MuraliKrishnan1980

  2 replies

  14 years, 7 months ago

  By: MuraliKrishnan1980

• SSIS Package failed while taking a back up usind execute sql task !!!

  Error: Cannot open backup device '\\servername\sharedfolderName\database.bak'. Operating system err…

  abhishek.8604

  3 replies

  14 years, 7 months ago

  By: abhishek.8604

• Unicode issues on SSIS package promotion

  Hello, I have a SSIS package that gets Oracle information and then is placed to the local SQL 2008 …

  Mithrandir

  3 replies

  14 years, 7 months ago

  By: Mithrandir

• SSIS 2005 calling Custom DLL

  I have a 2005 SSIS package that I'm trying to execute a custom DLL through a script task. I've com…

  pbrewer68

  1 replies

  14 years, 7 months ago

  By: Elliott Whitlow

• Data Profiling task for multiple tables

  I would like to run the Data Profiling task on a half-dozen tables in a database. Is there a bette…

  rgtft

  1 replies

  14 years, 7 months ago

  By: rgtft