Integration Services

• Topics

  Started by

  Posts

  Last post

• T-SQL Statement Task not running when scheduled

  I had the same issue when just pasting in syntax as a SQL job where it runs the syntax as the SQL A…

  Luv SQL

  23 replies

  8 years, 1 months ago

  By: Luv SQL

• send email for output of merge join

  Hi friends, I am having two tables1) Employee and 2) Manager. Both tables are on different sql serv…

  abhas

  3 replies

  8 years, 1 months ago

  By: Ant-Green

• 32Bit, Trying to run 64Bit in SSIS pkg and Job

  Hello, I took over a SQL Server 2016 system 1.5 yrs ago, and it connects to a Teradata DW for data …

  quinn.jay

  3 replies

  8 years, 1 months ago

  By: Phil Parkin

• Importing Variable length text files into SQL

  Hi I regularly import a set of Windows text files into SQL. These files are a fixed length and the …

  steve.alston

  8 replies

  8 years, 1 months ago

  By: Jeff Moden

• SSIS- Sharepoint online

  I would like to know the best way to get data from a SQL view/Table into a SharePoint Online list&n…

  PSB

  4 replies

  8 years, 1 months ago

  By: Sue_H

• SSIS Package - MySQL Error (Reading from the stream has failed) with SQL Server Agent

  Hi everybody, today i run into a strange problem.Create a simple package which transfers only data …

  PowerUser

  4 replies

  8 years, 1 months ago

  By: PowerUser

• Data not loading - but no errors - the package turns green after running.

  I have an SSIS package which has a sql task, foreach loop and data flow task inside the foreach loo…

  mtz676

  1 replies

  8 years, 1 months ago

  By: John Mitchell-245523

• How many child packges can be called in one master package ? any limit ?

  Hi Champs, How  many child packages can be called in one master package ?  i have  2…

  ravi@sql

  1 replies

  8 years, 1 months ago

  By: Thom A

• Using Redirect Rows with Data Access Mode Table or View is Slow

  We have a DFT with over 10 million records from 2 sources which goes through a merge join and …

  sadie

  10 replies

  8 years, 2 months ago

  By: sadie

• SSIS package Performance issue

  Hi All This is not about the code we have written in our package. We are assigned a task to migrate…

  vijay_uitrgpv

  2 replies

  8 years, 2 months ago

  By: Phil Parkin

• Started getting "AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009" suddenly

  Hello, I have SSIS package which worked fine for last 2 years and was successfully run in last mont…

  artisticcheese

  7 replies

  8 years, 2 months ago

  By: Thom A

• Need to zip files and load into Source Modified Date , Date folder.

  Hi, I have to zip files regularly and load them into destination, the destination folder should be …

  Sangeeth Raj

  8 replies

  8 years, 2 months ago

  By: Jeff Moden

• Compiling Interop Assembly into EXE

  Hello all, I'm having some trouble finding good resources for this online, so hopefully you experts…

  reelnoncents

  1 replies

  8 years, 2 months ago

  By: Phil Parkin

• Clob in Oracle convert into Varchar (max)

  I am using SSIS for SQl server 2014, try to import a column data type Clob into SQL server varchar(…

  sqlfriend

  2 replies

  8 years, 2 months ago

  By: sqlfriend

• how to load sql server table(varchar(max) or nvarchar(max)) data into text file using ssis

  Hi Friends I have one doubt in ssis how to load sql server table data into flat file using ssis pac…

  asrinu13

  1 replies

  8 years, 2 months ago

  By: Phil Parkin