Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS Newbie Here With Question

  Hello - i am tasked to build a ssis package that: 1. Grabs Data 2. Export it to Flat file 3. Ftp My…

  Keejli69

  10 replies

  12 years ago

  By: Keejli69

• Why does SSIS take so long to "build" before running?

  I have a ETL project that has about 15 packages in it, each package loads data into a SQL Server vi…

  MyDoggieJessie

  9 replies

  12 years ago

  By: Paul Hernández

• SSIS-Track Execution Time of a Data Flow Task

  Hi Everyone, I have this requirement,can any one give me an idea on how to implement this I have a …

  avinash.818

  8 replies

  12 years ago

  By: larskandersen

• Splitting single comma separated line

  Hi All, My source file is coma separated file having 6 columns. But some times two lines are mergin…

  abhas

  7 replies

  12 years ago

  By: Vikash Kumar Singh

• ssis working with existing package

  I have an SSIS package that I would like to open and see what it contains. I have never used an SSI…

  wendy elizabeth

  3 replies

  12 years, 1 months ago

  By: Evil Kraig F

• Getting imported file create date and storing it with the data

  Hi all, I am new to SSIS and have very very limited scripting knowledge so please be nice and simpl…

  dogramone

  9 replies

  12 years, 1 months ago

  By: Evil Kraig F

• Error handling

  Hi all, I want to do error handling using Script task in contril flow task. I have a table in my da…

  kapil_kk

  5 replies

  12 years, 1 months ago

  By: kapil_kk

• Data flow task (OLE DB) does not fetch all the stored procedure data

  I have an package that is used to import email items that is deployed on production and in daily us…

  Davio

  7 replies

  12 years, 1 months ago

  By: Davio

• SSIS and Null values

  Hi Everyone, I have package in SSIS. It has a execute sql task that gets some config values from a …

  alladiz

  5 replies

  12 years, 1 months ago

  By: Evil Kraig F

• Variable for Connection? How to Change file names dynamically?

  I have two different packages I am trying to run. One imports from an excel file the other a .csv f…

  jameslauf

  1 replies

  12 years, 1 months ago

  By: Russel Loski

• SSIS 2012 - Storing ConnectionStrings in Environments Question

  Hi, Does anyone know of a way to store a database connection string in an environment variable, but…

  Gabriel P

  2 replies

  12 years, 1 months ago

  By: PB_BI

• multiple files with some columns are same and some columns are different but i have to load all this columns into single columns how

  multiple files with some columns are same and some columns are different but i have to load all thi…

  bayapareddy.msbi

  8 replies

  12 years, 1 months ago

  By: Phil Parkin

• different files with some columns common and and some columns are different but i want to load all this into single table

  Hi, Actually i have 10 files which have 30 columns common in all files,but some files having additi…

  bayapareddy.msbi

  1 replies

  12 years, 1 months ago

  By: SQLRNNR

• Assigning an SQL NULL to an SSIS string - An SSIS Flaw ?

  Hi, I fetch a result set with an execute SQL task. It has only one column NullTime varchar. It has …

  blasto_max

  1 replies

  12 years, 1 months ago

  By: Evil Kraig F

• Developers and SSIS Packages settings in Visual Studio

  We are using SQL Server 2012 EE SP1 and Visual Studio 2010 Shell. We are just getting into creating…

  HookSQLDBA7

  7 replies

  12 years, 1 months ago

  By: Nevyn