Integration Services

• Topics

  Started by

  Posts

  Last post

• Passing string array to SSIS web service task from variable

  Hi all, I'm trying to run a web service task from within SSIS (2008 R2). If I key the input parame…

  Andrew Watson-478275

  1 replies

  10 years ago

  By: Andrew Watson-478275

• SSIS - How do I log timestamp when each individual task completed ?

  Please see the attached pic first. I like to add an event handler and in that I could setup a SQL t…

  mw_sql_developer

  2 replies

  10 years ago

  By: mw_sql_developer

• Count of a table, insert into another?

  I have put this here as I am still learning about SSIS and have assumed I can do this using this. S…

  Kazmerelda

  3 replies

  10 years ago

  By: Phil Parkin

• Script Task for File Exist

  Hello, I am trying to identify if the folder has all total 20 files before running load task. My fi…

  SQLKiller

  1 replies

  10 years ago

  By: karen.ferrara

• Any way to ensure to tasks in different ForLoops dont execute at same time?

  I have 2 dataflows that update the top 100k rows (A column called status to ready from staged), the…

  dndaughtery

  1 replies

  10 years ago

  By: dndaughtery

• Other Tools to Develop SSIS Package

  Good Morning Guys, I just what tools do i need so i can create a simple SSIS package. i currently h…

  Stylez

  7 replies

  10 years ago

  By: Stylez

• How to read Folder Names in SSIS

  Hi All, I have some folder names as dates, say 20151217 , 20151218, 20151219 etc (YYYYMMDD) and ma…

  only4mithunc

  5 replies

  10 years ago

  By: only4mithunc

• How to Execute SQL Task from Stored Proc & Then Query *THOSE* Results?

  I'm working on an SSIS pkg. that I need to run a stored procedure to return a pretty large results …

  brad.mccollum

  3 replies

  10 years ago

  By: Phil Parkin

• Load date time field to date field

  Hi All, I have a flat file source with a field of type date time ( it has got the data in Year-Mont…

  only4mithunc

  10 replies

  10 years ago

  By: only4mithunc

• SSIS error when configuring data flow task with .xls file

  Quick environment details: 64 bit Server 2008; SQL Server 2012; Studio 2010 I have a package that…

  J0shu@

  15 replies

  10 years ago

  By: Eric M Russell

• Incremental Loading using SSIS

  Hi Everyone, I created a ssis package to insert new records/update existing records into destinatio…

  sreeya

  23 replies

  10 years ago

  By: RonKyle

• Rollback transaction in SSIS

  Hi All, Need your help in below scenario. We have SSIS packages which involves Oracle and SQL serve…

  Sushant Yadav

  1 replies

  10 years ago

  By: Phil Parkin

• How to load different CSV files to different SQL tables

  Hi All, I have a requirement in which I have multiple CSV files ( columns and data are different in…

  only4mithunc

  3 replies

  10 years, 1 months ago

  By: only4mithunc

• Error: ForEach Variable Mapping number 0 to variable "ᶈ珈" cannot be applied

  Hi All, I am getting strange error mentioned below while executing my package. Error: ForEach Varia…

  rhythmk

  5 replies

  10 years, 1 months ago

  By: Sanjay Rohra

• SSIS DT_NTEXT to DT_STR conversion failure unicode and non-unicode Excel

  Just google "derived column dt_ntext to dt_str not working" and you will find numerous cases where…

  Question Guy

  11 replies

  10 years, 1 months ago

  By: kaza_rohan