Integration Services

• Topics

  Started by

  Posts

  Last post

• First Time Migration of a File System 2008 SSIS package from Dev to Prod

  Hi All, I developed SSIS packages in our development server. I used my windows id in the developmen…

  r_corp

  3 replies

  11 years, 2 months ago

  By: brosspaxedi

• SSIS transactions + different connections + without MSDTC

  Hi All, I have 2 tables source & destination and I have to truncate destination and laod from …

  sandhya.msbi

  1 replies

  11 years, 2 months ago

  By: Phil Parkin

• way to get just the latest file from stft site without scripting or creation of a sql table for parsing filenames?

  I'm using an Execute Process Task to connect to a remote sftp site and to get a file having a speci…

  KoldCoffee

  4 replies

  11 years, 2 months ago

  By: KoldCoffee

• what transform sequence to perform WHEN MATCHED, WHEN NOT MATCHED

  i have a source dataset in which multiple criteria have to match to the destination oledb table bef…

  KoldCoffee

  1 replies

  11 years, 2 months ago

  By: pietlinden

• SSIS multiple table loads using single DFT

  Hi, I am new to the SSIS. I am trying to load multiple tables from my staging database to multiple …

  vipin_jha123

  10 replies

  11 years, 2 months ago

  By: vipin_jha123

• Can't assign T-SQL parameter in OLE DB Source

  Ok I stumped! I have an SSIS OLE DB Source that uses a T-SQL Statement. I've tried and tested the …

  dave-dj

  11 replies

  11 years, 2 months ago

  By: abdouabdelhaqabdou

• SSIS XML file not found in 2012, but works in 2008?

  Hello, I have an SSIS 2008 package that goes to the following url (http://corpslocks.usace.army.mil…

  dobbinjp

  8 replies

  11 years, 2 months ago

  By: VoltronSabreRider

• ForEach Loop Question - Various Files with Different Formats to Different Tables

  Is there a good way to incorporate a ForEach Loop container for a scenario where I have about 100 d…

  joshdbguy

  4 replies

  11 years, 2 months ago

  By: rajarajansudar

• How to set or assign the dataset values to the Variable in Script TASK

  Here is my code below int counter = 0; string line; System.IO.StreamReader reader = new System.IO.S…

  rajarajansudar

  2 replies

  11 years, 2 months ago

  By: rajarajansudar

• How to se the dataset values to the Variable in Script TASK

  Here is my code below int counter = 0; string line; System.IO.Strea…

  rajarajansudar

  5 replies

  11 years, 2 months ago

  By: rajarajansudar

• SSIS Logging Variable Values

  I have a fairly basic SSIS package which contains several variables which can be overridden at runt…

  Mr. Bob Dobalina

  2 replies

  11 years, 3 months ago

  By: Aalam Rangi

• Connection Manager Expression set my Connection to Work Offline

  Hi, I was wondering if someone can help me. I am new to SSIS. I am going through these exercises in…

  rafaelc

  2 replies

  11 years, 3 months ago

  By: rafaelc

• Migrating DTSX Packages into Integration Services

  I've been tasked with moving all individual packages into Integration services for sql server 2014.…

  joshdbguy

  1 replies

  11 years, 3 months ago

  By: PB_BI

• Specifying Multiple Text Qualifiers For A Flat File ETL

  Is there a way to specify multiple text qualifiers for an ETL data flow. In a bunch of files I'm tr…

  joshdbguy

  1 replies

  11 years, 3 months ago

  By: Phil Parkin

• Using variable to evaluate part of file name?

  I have a file that gets placed in a folder every morning. I am building a package to import that fi…

  tiredofchoosing

  5 replies

  11 years, 3 months ago

  By: Phil Parkin