Integration Services

• Topics

  Started by

  Posts

  Last post

• The value violated the integrity constraints for the column while executing SSIS package

  I have created SSIS package which basically extract the dirty data from the table and using DQS Cle…

  jay.vraj.7

  2 replies

  8 years, 4 months ago

  By: jay.vraj.7

• SSIS "Script Task" Download File from SFTP

  Hi Guys, I need help, I am not good in C#. Below is C# code that I am using to download the file f…

  rocky_498

  4 replies

  8 years, 4 months ago

  By: sgmunson

• Extracting data to multiple folders

  I'm Extracting data into a file, I have o send the same file to multiple directories. So far it's e…

  hoseam

  3 replies

  8 years, 4 months ago

  By: Phil Parkin

• Read from excelm in SharePoint

  Hi,  How can I read from an excel file that is located in SharePoint using SSIS ? Below is how…

  PSB

  1 replies

  8 years, 4 months ago

  By: sgmunson

• failure precedence

  Hello,Package has several tasks connected to each other...I am introducing a failure precedence so …

  arkiboys

  3 replies

  8 years, 4 months ago

  By: sgmunson

• Processing multiple files from different directories

  I have 4 file directories, each with files to be processed into one Staging table. the files have s…

  hoseam

  3 replies

  8 years, 4 months ago

  By: frederico_fonseca

• SSIS package shows successful but not working

  I have an SSIS package that was executing successfully for some time but last week started erroring…

  Luv SQL

  20 replies

  8 years, 4 months ago

  By: tim.ffitch

• Extract multi value check box values from Sharepoint 2013

  We have an issue (using the ODATA connector) whereby we cannot extract data that is sourced from a …

  wannabe_developer

  2 replies

  8 years, 4 months ago

  By: sgmunson

• Creating a SSIS package which will call the stored procedure and output results into a tble

  Hi, I think I understand the logic but but strugling to implement it, I created a package and creat…

  hoseam

  4 replies

  8 years, 4 months ago

  By: Thom A

• SSIS 2008 - Combining rows from the same table

  Hi, I'm quite new to SSIS so I'm more asking for to be pointed in the right direction here than for…

  awalker 76056

  5 replies

  8 years, 4 months ago

  By: henryKrinkle

• Exception of type 'System.OutOfMemoryException' was thrown. When Saving package

  I'm getting an Exceptionof type 'System.OutOfMemoryException' was thrown. error when I try to save …

  dndaughtery

  1 replies

  8 years, 4 months ago

  By: dndaughtery

• Data flow concept - Thoughts wanted

  Looking for thoughts on this. I have an application where we receive data from customers via text …

  Tom_Hogan

  32 replies

  8 years, 4 months ago

  By: Orlando Colamatteo

• Merge Join is not working properly

  Hi there 🙂 I really need some help and I thought, and will be really glad, you can help me. I …

  camsuarezmun

  3 replies

  8 years, 4 months ago

  By: Phil Parkin

• Flat File Connection Manager

  Hi, I have a file directory path were I get a csv file per day, with current date. I have set up Fl…

  hoseam

  18 replies

  8 years, 4 months ago

  By: Thom A

• Using CDC Control Component for Initial Load with Read-Only Database

  I have an active CDC enabled SQL Server database with 4 tracked tables that I need to load into Ama…

  Wolfmeister

  3 replies

  8 years, 4 months ago

  By: Wolfmeister