Integration Services

• Topics

  Started by

  Posts

  Last post

• Failed to create an IDataAdapter object. This provider may not be fully supported with the Execute SQL Task

  I executed a simple query inside an execute SQL task - SELECT col1, col2 from thetable where code …

  blasto_max

  3 replies

  12 years ago

  By: blasto_max

• Stored procedures to flat files from ssis

  My source as multiple stored procedures names stored in a table and I need to generate a flat file …

  etirem

  8 replies

  12 years ago

  By: etirem

• OLE_SRC doesn't bring back record

  Using SSIS 2008 R2, I've got a query in an OLE DB Source task that works fine in SSMS and about 2/3…

  robert.gerald.taylor

  2 replies

  12 years ago

  By: robert.gerald.taylor

• Is there any specific reason that ssis pkg takes long time to execute

  Hi Everyone, I had been asked in interview that what are the steps we should take if ssis pkg takes…

  sharmili.net

  8 replies

  12 years ago

  By: blasto_max

• Looping through Foreach loop on monthly basis

  Hi all, I am trying to loop through the ForEach Loop Container,on monthly basis in SSIS. I was not …

  Shadab Shah

  2 replies

  12 years ago

  By: Lowell

• How to write data from multiple stored procedures(which has parameters) to files using SSIS script task?

  http://stackoverflow.com/questions/7095930/how-to-write-data-from-multiple-stored-procedures-to-fil…

  etirem

  1 replies

  12 years ago

  By: Jeff Moden

• Move table to different Destination

  Hi I have x(Source) table in one server and Y(Destination) table in different server and i have a…

  Honny

  2 replies

  12 years ago

  By: Honny

• Pass SSIS Object to child SSIS package

  I tried to pass a SSIS Object (actually a DataSet) to a child package. I got an error which tells m…

  blasto_max

  11 replies

  12 years ago

  By: Jeff Moden

• how to pass variable to oledb source

  hi guys i've created sql task with the following query 'SELECT MAX(wwo.StatusChangedOn) AS MaxDate…

  Nomvula

  5 replies

  12 years ago

  By: Nevyn

• Webservice as A Data source

  Hi All I have a requirement like My source is webservice from which I need to Pull Data and put it …

  greeshatu

  3 replies

  12 years ago

  By: Phil Parkin

• Skip Header Rows in Excel and Concatenate Excel column names in SSIS

  Hi, I am trying to load data from an excel sheet to a sql server table. The first two rows in excel…

  Learning1

  11 replies

  12 years ago

  By: Phil Parkin

• Execute Package Utility: Set boolean property value

  I have a boolean variable in my package called [User]::InitialLoad. The variable defaults to "Fals…

  gbritton1

  1 replies

  12 years ago

  By: gbritton1

• ERROR opening SSIS Packages

  Hi All, I am facing issues opening SSIS packages which I have taken from TFS. The error is attached…

  syedathariqbal

  4 replies

  12 years ago

  By: Elliott Whitlow

• SSIS Data validation

  Hello, In my company we receive data files from customers. Most often some type of text based flat …

  gerendfs

  2 replies

  12 years ago

  By: Lempster

• send notification error task level and package leve useing ssis script

  hi friends i have small doubt in ssis how to send email noftification task level or package lev…

  asranantha

  1 replies

  12 years ago

  By: Lempster