Integration Services

• Topics

  Started by

  Posts

  Last post

• Only one column not extracting from Excel source

  I am trying to extract the data out of an excel file with 3 columns Success, Failure and Waiting. T…

  rockstar283

  4 replies

  12 years, 12 months ago

  By: Scott Murray-240410

• Extracting data from specific cell in Excel using Script task

  Hi..I have an excel file with data and want to extract the value from C2 cell only..here is my code…

  rockstar283

  1 replies

  12 years, 12 months ago

  By: rockstar283

• SSIS task taking time but SP called is quick

  Hi, We have a huge process that we perform using SSIS, which is mostly just calling SP's using SQL …

  namrata.dhanawade-1143388

  6 replies

  12 years, 12 months ago

  By: namrata.dhanawade-1143388

• SSIS File Import Collation

  I am using SSIS to import text files, which include french accented characters in some fields, from…

  p.m.kavanagh

  2 replies

  13 years ago

  By: Silvia Acevedo

• Documentation in SSIS

  I am just starting learn and use SSIS, and was wondering how you document changes? In a stored proc…

  dwilliscp

  5 replies

  13 years ago

  By: dwilliscp

• Package encryption and Source Code Control

  Hi guys, Background: We are using Mercurial Hg Source code control for our SSIS solutions. Currentl…

  aaron.reese

  2 replies

  13 years ago

  By: Phil Parkin

• Audit transformation in SSIS

  Hi everyone. This is my first time posting on this forum so let me know if you need more informatio…

  daniel-johnsson

  10 replies

  13 years ago

  By: Phil Parkin

• Wierd behavior from an Aggregate dataflow task

  Hi guys, I just wanted to know whether anyone else has experienced this and if so what the solution…

  aaron.reese

  3 replies

  13 years ago

  By: aaron.reese

• Integration Services DB

  Hi - can anyone tell me where the integration services DB is "stored" please? On SQL 2000 DTS was i…

  allen davidson

  2 replies

  13 years ago

  By: allen davidson

• T-SQL Merge over databases in different servers

  Hi Folks, I would like to know if it´s possible to use the T-SQL MERGE if the source DB is a DB2/AS…

  Paul Hernández

  5 replies

  13 years ago

  By: Phil Parkin

• SQL license question related to the SSIS loop transform

  Is a "lookup transform" considered part of the "basic transformations" included in sql server stand…

  Rodney Workman

  1 replies

  13 years ago

  By: Orlando Colamatteo

• Cant run SSIS Package from "SQL Server"

  Newbie having an issue. I have job configured in sql agent to run a package on the file system.... …

  cjbaum

  2 replies

  13 years ago

  By: cjbaum

• SSIS task perform PGP encryption with remote server

  Hello, I have an SSIS package with a task that I need to perform PGP encryption. I am running the …

  cafescott

  2 replies

  13 years ago

  By: cafescott

• Passing Multiple variables to dtexec in execute process task

  Hi, how to pass multiple variables to dtexec in execute process task. it is working fine when i pas…

  sqlbi

  1 replies

  13 years ago

  By: Rick Krueger

• Disappearing scriptmain.vb from a script component

  Hello, I am doing some research into moving to SQL 2012 from SQL 2008 R2. As a part of this I am m…

  padre

  1 replies

  13 years ago

  By: cafescott