Integration Services

• Topics

  Started by

  Posts

  Last post

• 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, 1 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, 1 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, 1 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, 1 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, 1 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, 1 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, 1 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, 1 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, 1 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, 1 months ago

  By: Phil Parkin

• SSIS Access

  I have installed SSIS after installing SQL Server 2014 two months ago. I can log in to SSIS from my…

  SqlServerDBA318

  5 replies

  11 years, 1 months ago

  By: SqlServerDBA318

• what is "Integrated Security" in SQL Connection

  hi what is "Integrated Security" in SQL Connection? and it must be false or true? thanks

  armm1388

  2 replies

  11 years, 1 months ago

  By: t.pratiksha

• Datatype issue

  I have to load excel files in a sql table. In one of the column, some rows has string and some rows…

  subaprati

  2 replies

  11 years, 1 months ago

  By: t.pratiksha

• Isnumeric check in Expression Builder

  Hello, I am new to SSIS, just wanted to know if I can add Isnumeric check in Expression builder. I …

  t.pratiksha

  4 replies

  11 years, 1 months ago

  By: t.pratiksha

• SSIS CONFIGURATION ISSUE - ERROR

  I have been looking for answers on several different locations, but can't seem to find one. When I …

  SqlServerDBA318

  7 replies

  11 years, 1 months ago

  By: SqlServerDBA318