Integration Services

• Topics

  Started by

  Posts

  Last post

• how boolean is converted to bit

  I have a source like pkg_in.xml_p (decode(b.is_flg,1,'False','True'), 'ISDFLG') So from source i…

  mcfarlandparkway

  2 replies

  9 years, 4 months ago

  By: mcfarlandparkway

• Load few tabs from excel

  Hello all, Hope all are doing good! 🙂 I am having a excel sheet which will contains around 20-24 t…

  abhas

  3 replies

  9 years, 4 months ago

  By: Phil Parkin

• Dynamic Connection String Passed Through C#

  I'm trying to create an interface that a user can select an environment to execute a package agains…

  Kyle Sherry

  3 replies

  9 years, 4 months ago

  By: Phil Parkin

• Changing destination csv filename

  I apologize if this question has been already asked and answered, but I have yet to find a good sol…

  Brad Allison

  12 replies

  9 years, 4 months ago

  By: Phil Parkin

• Using temp tables in stored procedures for data flow source in SSIS 2012?

  Hi there, I tend to use stored procedures as dataflow sources and, quite often, I use temporary tab…

  Eric Mamet

  17 replies

  9 years, 4 months ago

  By: kristib

• Downgrading an ETL project from SSIS 2014 to SSIS 2012 - The version number in the package is not valid. The version number cannot be greater than current version number.

  Hi Can anybody assist me? These explanations(http://blog.haunschmid.name/downgrading-an-etl-project…

  yrstruly

  3 replies

  9 years, 4 months ago

  By: prvmine

• SSIS/C# Help.

  Hi Guys, I am not sure it is possible or not. Never done it before so not sure. Need guidance.... …

  rocky_498

  2 replies

  9 years, 4 months ago

  By: frederico_fonseca

• SSIS pacakge runs fine but SQL server job that runs package fails

  I have a pacakge taht runs fine in the SSISDB but when i schedule it fails saying unable to access …

  komal145

  3 replies

  9 years, 4 months ago

  By: Thom A

• Problem with Web Service Task

  Hello. I can't successfully create a web service in SQL Integration Services because the next error…

  javierja16

  13 replies

  9 years, 4 months ago

  By: MMartin1

• SSIS integration services not in services

  Please find the below attachment.I have sql server 2014 express version downlaoded and Visual studi…

  komal145

  6 replies

  9 years, 4 months ago

  By: Sue_H

• SSIS process row

  I have 60 rows ,SSIS processed 20 rows and 21 rows got error, now I want my package to run from tak…

  coool_sweet

  4 replies

  9 years, 4 months ago

  By: Alvin Ramard

• data into new file

  in my ssis package , i have 6000 rows coming and i am puttingin 1 file. now my requirement is if mo…

  coool_sweet

  1 replies

  9 years, 4 months ago

  By: Phil Parkin

• task rollback

  hi i have four execute sql task in my package. what i need to do if any of the task fails,example t…

  coool_sweet

  2 replies

  9 years, 4 months ago

  By: coool_sweet

• Script (C#) to add row to Object Variable (SSIS 2008 R2)

  Hi, Is it possible to... 1) create an empty, no rows, Object Variable from a table structure. Possi…

  SteveD SQL

  9 replies

  9 years, 4 months ago

  By: MMartin1

• EXCEL destination error: Column names used more than once

  I have oledb source to excel destination. I have data conversion transformation to cahnge the datat…

  komal145

  4 replies

  9 years, 4 months ago

  By: Alvin Ramard