Integration Services

• Topics

  Started by

  Posts

  Last post

• Integration Services & Multiple Developers

  Hello I work in a newly created BI team. We have experience using Business Objects for ETL and some…

  ElNevera

  6 replies

  10 years ago

  By: ElNevera

• SSIS query produces different results over the day.

  Hi All I have a SSIS dataflow task that pulls data from my staging table, this table for example ha…

  Sl33py

  13 replies

  10 years ago

  By: Phil Parkin

• When FTP File Does Not Exist

  I've got some C# that checks a server via FTP to see if a file exists and then if it does it uses t…

  DKY

  8 replies

  10 years ago

  By: David-611362

• filter monthly activity file from yearly file

  Client send a YEARLY Data file every month and I want to take that YEARLY file and filter the date …

  Rankerg

  3 replies

  10 years ago

  By: Jeff Moden

• Script Prompt to Select Path Connection String for Variable

  Is there a script that brings up a prompt that allows user to navigate/select path of flat file con…

  jSqlB

  9 replies

  10 years ago

  By: Alvin Ramard

• ideas for file import and process

  Hi, I have a process that will import a txt file each month. There will be 2 separate txt files. On…

  scottcabral

  4 replies

  10 years ago

  By: Lowell

• want to run .exe file in remote server from my local machine

  Wish you a very happy new year. Start of the new year gives me a challenge. I need to run an .exe f…

  niladri.primalink

  4 replies

  10 years ago

  By: Eric M Russell

• Error running SSIS package (SQL Server 2012) using VS 2012 (framework 4.0)

  When I try to run a SSIS package (built in SQL Server 2012, BIDS VS2010) from a console application…

  rs80

  1 replies

  10 years ago

  By: Andrew G

• Mapping Network Drive with Net Use does not work via SQL Agent

  Looking for a direction on solving an issue I am experiencing with running a SQL Agent job. Running…

  nothingisnotnull

  1 replies

  10 years ago

  By: Andrew G

• How to stop the Winzip prompt showing when executing Exec process Task in SSIS

  I have the following values for the settings in the Exec Process task which is inside of a ForEach …

  dndaughtery

  5 replies

  10 years ago

  By: Matt Miller (4)

• SSIS 2012 Execute SQL Task with resultset to populate user variables produces DBNull error.

  I am experiencing an unexplainable behavior with the Execute SQL Task control in SSIS 2012. The fo…

  Scott Clark-275269

  6 replies

  10 years ago

  By: dbaRian

• Simple dataflow gets hung on

  I have a simple ssis dataflow with one input (from a staging db) and two outputs (one to a target d…

  g.britton

  1 replies

  10 years ago

  By: g.britton

• SQL Server 2008 R2. SSIS not using Shared Memory.

  I'm debugging a SSIS package running on SQL Server 2008 R2. It reads from a staging table (in a s…

  g.britton

  2 replies

  10 years ago

  By: g.britton

• Dynamically changing the value in Conditional split

  Hi All, I have source flat file , I want to exclude the records containing below state. I have crea…

  vipin_jha123

  5 replies

  10 years ago

  By: Phil Parkin

• Header and Detail SSIS

  In our SQL Server 2012 database we have a Header view and a Detail view that collects data from our…

  bpowers

  2 replies

  10 years ago

  By: bpowers