Integration Services

• Topics

  Started by

  Posts

  Last post

• Control Flow: differentiating between source files already processed/not processed

  I have to import zip files every day from a vendors ftp site who leaves the last 7 days on the ftp …

  KoldCoffee

  10 replies

  11 years, 8 months ago

  By: Maninder Kumar

• Datatype conversion issue

  i have a ssis package imports msaccess data to sql. i am getting an error as below. I checked the y…

  scuby.me

  3 replies

  11 years, 8 months ago

  By: Jack Corbett

• Excel import - force column to be string (SSIS 2005)

  I know this topic has been covered in a few places - but it reoccurs regularly and I have NOT got a…

  dwill

  23 replies

  11 years, 8 months ago

  By: Zahid Naseer

• Force SSIS package to return success status to Agent Job

  Hi All, I have a master SSIS package which calls multiple other SSIS packages. One of these sub-pa…

  David.Lester

  2 replies

  11 years, 8 months ago

  By: David.Lester

• In control flow: how to create date time stamp to use in downstream tasks.

  I have a control flow which unzips 14 unique files, drops them into a process folder, and then afte…

  KoldCoffee

  4 replies

  11 years, 8 months ago

  By: KoldCoffee

• Execute Process Task: how can I make the task's argument and executable fields use the expressions I built for them??

  I've got a series of Execute Process Tasks whose arguments and executable fields I would like to po…

  KoldCoffee

  2 replies

  11 years, 8 months ago

  By: KoldCoffee

• SSIS 2012 Catalog vs. File System (or project vs package deployment)

  We recently migrated from 2008R2 to 2012. We are still using the file system deployment method for …

  Jason Marshall

  2 replies

  11 years, 8 months ago

  By: Jason Marshall

• NewApplication vs badcustomers in SSIS

  Hi Can any one suggest me how to achieve below in SSIS I have customers name fields as Name1, Name2…

  venkat5677

  2 replies

  11 years, 8 months ago

  By: venkat5677

• Need expression of file name attachment to include the Month in the Year in a specific format.

  I need expression of file name attachment to include the Month in the Year in a specific format. Th…

  Welsh Corgi

  4 replies

  11 years, 8 months ago

  By: Welsh Corgi

• Find \ Replace within a .csv

  I would like to execute a simple find and replace of a single character within the contents of a .c…

  J0shu@

  7 replies

  11 years, 8 months ago

  By: J0shu@

• Random Data is inserted in SSIS

  Hi I m using SSIS to transform the data from csv file(which has fixed width as delimiter) to databa…

  gajayku

  7 replies

  11 years, 8 months ago

  By: Koen Verbeeck

• Problem with SSIS connection manager while running from SQL job

  I am facing below issue while executing SSIS package via SQL job: Description: The connection strin…

  Maninder Kumar

  2 replies

  11 years, 8 months ago

  By: Maninder Kumar

• Sent Mail task

  Hi All, I am new to SSIS, I have a 39 tables in source and same tables in destination, The source a…

  annam.dba

  3 replies

  11 years, 8 months ago

  By: Lempster

• Convert .xlsx to .txt

  I need to generate a .txt file via a SSRS report. My thought was to export the report as .xlsx then…

  J0shu@

  6 replies

  11 years, 8 months ago

  By: Umer Akram

• dynamic database connection of bulk insert task in foreach loop

  i am trying to accomplish a task in which bulk insert task which is inside a foreach loop accept dy…

  hussainismail

  7 replies

  11 years, 8 months ago

  By: hussainismail