Integration Services

• Topics

  Started by

  Posts

  Last post

• Why am I having to change the connection in the package whenits using a config

  I have a package where I have configurations setting the connection managers info. The thing I've n…

  dndaughtery

  2 replies

  11 years, 9 months ago

  By: dndaughtery

• Integration Service Dashboard & Row Counts

  I recently learned that SQL Server 2012/SSIS 2012 has a feature called the Integration Service Dash…

  imani_technology

  7 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• SSIS Strange error when running as SQL Agent

  So I have a package that runs correctly from my local machine in BIDs, but gives the following erro…

  Wesley Middendorff

  12 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• how to import excel sheet with varying no. of columns in ssis

  Hi, I have a requirement to import excel sheet which we receive daily, sometimes it may contain ext…

  ykonline

  1 replies

  11 years, 9 months ago

  By: Eirikur Eiriksson

• Sending Emails with SSIS however have a Script Task Error

  HI, Hope there is someone out there that can help me. I have a package which enables me to take a d…

  Healthdata

  4 replies

  11 years, 9 months ago

  By: Phil Parkin

• This table contains cells that are outside the range of cells....

  Hello again. I had my SSIS package working; it gathers data and depending whom is currently being …

  cafescott

  1 replies

  11 years, 9 months ago

  By: cafescott

• Executing package on another server fails

  Hi, SSIS 10.50.2500 I have created a package that runs fine on ServerA (where I developed the packa…

  hristo1977

  4 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• passing variables in a Foreach loop container

  Hi all, I hope this is the right forum to post, else please let me know. I'm not an expert with SSI…

  petitpere

  8 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• shouldn't variables in a Foreach Loop be resolved automatically?

  I've been experimenting with a simple loop to read through .csv files in a folder and use 7-zip to …

  deeby

  3 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• execute process task fails

  Hi All, I upgraded a package from DTS to SSIS 2008 r2 which includes one Script task and two exec…

  venkat5677

  6 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• Updating your fact table when a scd changes

  so you have a slowly changing dimension that has changed somehow say product color code has changed…

  ps_vbdev

  1 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• SSIS Connection Mgr , set in SQL Server Config Failing

  I have an ssis pkg which uses a SQL Server db table to hold the configurations. When I run the pack…

  dndaughtery

  1 replies

  11 years, 9 months ago

  By: Jack Corbett

• SSIS Script Task to capture EXIT codes from .bat file - How?

  *Headthump* Alright, Mr. VB I'm not, and I'm okay with that, but I'm about to throttle this thing. …

  Evil Kraig F

  5 replies

  11 years, 9 months ago

  By: Evil Kraig F

• Copy and Rename Files based on Query Results

  Afternoon Everyone, Im caught in a bit of a sticky SSIS problem. So the background. We have a set o…

  waxb18

  5 replies

  11 years, 9 months ago

  By: waxb18

• error when extracting from excel to sql server data are nort all extracting why ?

  hi all when extracting data from excel to sqserver and runing SSIS project the destination OLE DB b…

  prepaess

  8 replies

  11 years, 9 months ago

  By: Koen Verbeeck