Integration Services

• Topics

  Started by

  Posts

  Last post

• Isi it possible to have a dynamic header row in a FlatFile Destination?

  I have a flat file destination and I'd like to add some dynamic values (date and time values) to th…

  dndaughtery

  1 replies

  10 years, 1 months ago

  By: Dave Morrison

• Easy one for someone that knows C#

  I have a spreadsheet that comes in the same format every month. The source, unfortunately, puts tw…

  CptCrusty1

  4 replies

  10 years, 1 months ago

  By: CptCrusty1

• ETL and Data Analysis

  I'm looking for some white papers or articles that demonstrate the necessity and/or roles that Anal…

  CptCrusty1

  3 replies

  10 years, 1 months ago

  By: Martin Schoombee

• How to know if data is committed after an insert

  We have an SSIS package that is just inserting data into a table. This is run by an SQL server agen…

  dplaut 49149

  7 replies

  10 years, 1 months ago

  By: dplaut 49149

• Transfer Database Task

  Hi All, I'm trying to process a Transfer Database task from a SQL 2008 server to a SQL 2012 server.…

  Thom A

  4 replies

  10 years, 1 months ago

  By: MMartin1

• change the executing machine

  Hi, I have a package installed on a SQL 2012 instance (called "instance A") in the SSISDB catalog. …

  Barkstuff

  1 replies

  10 years, 1 months ago

  By: MMartin1

• Check for duplicates before inserting

  I have a SSIS job that is failing due to inserting duplicate values into a primary key. The issue …

  dan-572483

  7 replies

  10 years, 1 months ago

  By: MMartin1

• Data Flow Task working very slow due to left join in source

  Hi frnds, I have one DFT which is having straight source to destination mapping.In Source I am usin…

  Re1

  11 replies

  10 years, 1 months ago

  By: Barkstuff

• Where do I find Microsoft.SqlServer.Management.IntegrationServices.dll?

  I would like to explore deploying SSIS 2012 packages through a C# interface. Where can I find the M…

  Eric Mamet

  5 replies

  10 years, 1 months ago

  By: _watching

• automate weblink to csv to database

  Hi , i need to automate on the below 1.call the webservice link , it will generate one csv file 2.…

  Lavanyasri

  1 replies

  10 years, 1 months ago

  By: Thom A

• SSIS , Debug C# script performing http download of zip file with security

  All: Looking for hints/tips on debugging C# script in V.S. 2010. Need to find way to debug inte…

  rsampson

  1 replies

  10 years, 1 months ago

  By: mister.magoo

• Question regarding ANONYMOUS login within a Backup and Restore Package

  Hello I have a package with 3 tasks 1. Backup a database to a specific location on our network (Bac…

  DamianC

  4 replies

  10 years, 1 months ago

  By: joeroshan

• Using SSIS variables as input parameters for stored proc in OLE DB connection manager

  I'm using SSIS 2008R2. I have a data flow task with an OLE DB connection manager using Data access …

  lduvall

  1 replies

  10 years, 1 months ago

  By: Jack Corbett

• column code page warning in lookup transformation

   Regarding the warning about "Cannot retrieve the column code page from the OLE DB provider. I…

  rana-408456

  3 replies

  10 years, 1 months ago

  By: crkuchlenz

• how to fix The requested OLE DB provider OraOLEDB.Oracle.1 is not registered.

  I have copied the SSIS packages from the TFS source folder to my local path. The SSIS package is co…

  abhishek_300

  1 replies

  10 years, 1 months ago

  By: Jo Pattyn