Integration Services

• Topics

  Started by

  Posts

  Last post

• Hold data path in Lookup SSIS

  Hi , In my SSIS Package I am loading data from source to destination. I am using lookup to get the …

  vipin_jha123

  1 replies

  10 years, 5 months ago

  By: Umer Akram

• import data in sql table from sql server database from another domain

  Hi, I have read right on production environment and read-write access on development environment. P…

  akash_singh

  7 replies

  10 years, 5 months ago

  By: MikeTomkies

• How to generating Unique keys on the basis of multiple column in ssis

  Hi, I have one table in SQL where data coming from source oracle. Itmkey is not there in source and…

  vipin_jha123

  2 replies

  10 years, 5 months ago

  By: michal.lisinski

• Need ADO.NET Source SQL command to reference a list dynamically

  Hello, I'll try to explain my requirement as clearly as possible. I have an ADO.NET source that pu…

  latingntlman

  9 replies

  10 years, 5 months ago

  By: MikeTomkies

• Read a file from FTP directly

  Hi, I have some excel files stored in a FTP folder. I want to transfer data from these excel files …

  karthik82.vk

  4 replies

  10 years, 5 months ago

  By: Jeff Moden

• Read the result set ( stored in a variable ) from execute SQL task

  I am running a query and stored the result set ( multiple columns as full resultset rows ) in a var…

  komal145

  4 replies

  10 years, 5 months ago

  By: komal145

• Finding the origins of a SSIS package

  Hello I have inherited a few SSIS packages along with some jobs that run them. I am able to find th…

  DamianC

  2 replies

  10 years, 5 months ago

  By: DamianC

• Lookup Transformation - Urgent

  Hi Team, I have a data flow which loads data from Source SQL to destination SQL tables . In between…

  sql crazy kid

  3 replies

  10 years, 5 months ago

  By: sql crazy kid

• Asynchronous Data Flow - How to add conditional wait

  I have a data flow that will check imported data against the db and Insert new records. I decided t…

  Chad.Kemp

  6 replies

  10 years, 5 months ago

  By: Martin Schoombee

• Load Data from one server to another server (issues)

  I have a query where it has atleast 4-5 temporary tables and finally data is selected from that tem…

  komal145

  3 replies

  10 years, 5 months ago

  By: komal145

• SSDT-BI tool for SQL 2014 doesnot work with oracle 12c oledb driver

  Just install a new SQL server 2014 instance. And install Oracle 12 c OLEDB driver from Oracle clien…

  sqlfriend

  6 replies

  10 years, 5 months ago

  By: sqlfriend

• Move txt file from one folder to another using Script task

  Hi All, I have 2 variable 1.Source and 2.Destination both variable contain the source file path and…

  vipin_jha123

  3 replies

  10 years, 5 months ago

  By: Phil Parkin

• Sorted File Enumerator (SSIS)

  Hello, I am looking for solution how to loop through sorted list of files and load them into databa…

  g1696412

  1 replies

  10 years, 5 months ago

  By: Jo Pattyn

• SSIS Data Flow - Custom Data Source

  Hi there, I've been looking around for a bit to find a good starting point for my problem and have …

  Chris Rutherford

  1 replies

  10 years, 5 months ago

  By: Phil Parkin

• Calculate checkSum for a flat file connection

  My requirement is to create a text file with header ,detail and trailer records. The trailer record…

  happy55

  4 replies

  10 years, 5 months ago

  By: Scott Coleman