Integration Services

• Topics

  Started by

  Posts

  Last post

• "Invalid column type from bcp client for colid xx."

  Hello, I have an issue with transferring some data from prod to uat, the two tables are identical. …

  Duran

  2 replies

  8 years, 2 months ago

  By: Phil Parkin

• [SQL 2014 - SSISDB] - Issue: Exception has been thrown by the target of an invocation in SSIS Script task with C# code, (Version 12.0.0.0, 32-bit mode)

  Hi All,There is a package with script task deployed on server and there is a job to execute it, if …

  michal.lisinski

  2 replies

  8 years, 2 months ago

  By: Thom A

• Excel drivers for ssis package

  Hi, I am trying to connect to excel source but its throwing connection error. After googling it sug…

  sqlsniffer

  19 replies

  8 years, 2 months ago

  By: Umer Akram

• Data Flow Task Error: The version of ODBC Source is not compatible with this version of the DataFlow

  So, that is the error I am getting when I attempt to execute my extremely simple SSIS package. &nbs…

  bikerdadHLV

  17 replies

  8 years, 3 months ago

  By: madhuvrpr

• 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 months ago

  By: Thom A