Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS 2005 Interview Questions

  Hi All, Please provide me a link from where I can download the SSIS/SSAS/SSRS 2005 interview questi…

  ashish.mehrotra

  7 replies

  11 years, 3 months ago

  By: Stuart Davies

• Sql 2012 Ssis row by row processing

  I am converting data from one db to another and one of the main tables is a master name tables. The…

  teareal_1

  4 replies

  11 years, 3 months ago

  By: Koen Verbeeck

• Flat file read , conditionally extract data rows

  This is urgent please. Use SSIS flat file sample content (use attachement, sampleFF), ABC 8585 …

  daniarchitect

  5 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• copy table with data from one server to other

  Hi all, I am having SP which gives dynamic resultset. i.e.number of columns varies from min 5 to m…

  abhas

  1 replies

  11 years, 3 months ago

  By: g.britton

• Getting Error while executing SSIS package - need quick help

  Hi All, While executing one of package in PROD environment we are getting below error. component "…

  rhythmk

  8 replies

  11 years, 3 months ago

  By: MMartin1

• SSIS 2012 / ragged right query

  Hi folks, I've got a query (most likely my interpretation) of importing ragged right files in SSIS …

  paulyw

  6 replies

  11 years, 3 months ago

  By: stevefromOZ

• Using SSIS 2008 to handle file retention

  Everything I have found, searching the internet, uses C# 2010 code, and when I put the code into 20…

  dwilliscp

  3 replies

  11 years, 3 months ago

  By: dwilliscp

• Creating the SSIS 2012 package using C#(To run a SSIS package outside of SQL Server Data Tools you must install sourceErrorDesc_LOOKUP_MODE of Integration Services or higher)

  I am in upgrading my code written in 2008 to 2013 .net , when I the run the code I get erro…

  rajarajansudar

  6 replies

  11 years, 3 months ago

  By: rajarajansudar

• 'Invalid access to memory location' error in Jobs but not in BIDS

  Hi, On running the parent package in nightly schedule job gives an 'Invalid access to memory locati…

  mckyn

  4 replies

  11 years, 3 months ago

  By: Phil Parkin

• compare two datasets using ssis

  Hi, I have two tables in SQL server database. i want to compare both tables and differentiate like …

  scuby.me

  1 replies

  11 years, 3 months ago

  By: Phil Parkin

• How to check the Value exists in another Table

  Hi , I am kind of in Confusion in some simple logic i believe , so i need the help of you all .…

  Guitar_player

  4 replies

  11 years, 3 months ago

  By: Guitar_player

• 2K8R2 SSIS Script Component is setting readonly variables?

  So, I've got a confusion. I have a simple script component. The readonlyVariables line looks like …

  Evil Kraig F

  8 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• Get name of user with excel file open

  Hi, Is it possible to get the name of the user that has an excel file open. At present I have a fil…

  Kev

  1 replies

  11 years, 3 months ago

  By: Lowell

• WQL Query to use in WMI Event Watcher Task - watch for new file being added

  Hi. I am trying to have a event watcher task monitor for when a specific file gets added to a direc…

  MMartin1

  6 replies

  11 years, 3 months ago

  By: MMartin1

• Debugging SSIS package using dtexec console and console.writeline.

  Hi, I have a silly issue when trying to debug SSIS package. When I run the package via dtexec and …

  Ronnie-651316

  2 replies

  11 years, 3 months ago

  By: alex.myles