Integration Services

• Topics

  Started by

  Posts

  Last post

• Best way to narrow results

  I am trying to figure out the best way to do this... I have a table with millions of records for or…

  robert.wiglesworth

  3 replies

  9 years, 1 months ago

  By: Thom A

• File system task - illegal characters in path

  [File System Task] Error: An error occurred with the following error message: "Illegal characters i…

  Jay@Work

  2 replies

  9 years, 1 months ago

  By: Jay@Work

• SSIS extract package problems with SQL Agent Job - Salesforce to SQL Server

  Hi Guys, I have built a ETL package using SQL Server 2014, it extracts from a Salesforce source goi…

  Jim-S

  1 replies

  9 years, 1 months ago

  By: Jim-S

• SSIS Packages --> 2 questions

  Hi, sorry in advance for the n00b questions, but I'm very new to SSIS. Here's the story: for my wor…

  Super_Grover

  7 replies

  9 years, 1 months ago

  By: Super_Grover

• Change Detection with (44) Columns!

  I am mirroring about (23) tables in another DW. I have built my first incremental loads package, f…

  Jerid421

  9 replies

  9 years, 1 months ago

  By: MMartin1

• [Execute SQL Task] Error: Executing the query "EXEC UpdateSSISLog ?" failed with the following error: "The batch could not be analyzed because of compile errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection n

  I used the following as an example to return a single result set: https://www.simple-talk.com/sql/…

  Welsh Corgi

  1 replies

  9 years, 1 months ago

  By: Welsh Corgi

• AcquireConnection method call fails - Excel

  I keep getting the error listed below: [Import_Credit [36]] Error: SSIS Error Code DTS_E_CANNOTACQU…

  Welsh Corgi

  4 replies

  9 years, 1 months ago

  By: Welsh Corgi

• SSIS ODBC Connection manager error when testing connection

  Hey guys, I'm trying to create an ODBC connection manager. I open the admin tools, select ODBC Data…

  dndaughtery

  1 replies

  9 years, 1 months ago

  By: dndaughtery

• Input string format error in Execute Sql Task

  I have an Execute Sql Task where I am using this SP. CREATE PROCEDURE [dbo].[InsData] @DB VARCHAR(2…

  mcfarlandparkway

  9 replies

  9 years, 1 months ago

  By: Phil Parkin

• SSIS Task to check for Null or empty string and fail Package

  Years ago I created an SSIS Task to check for Null or empty string and the fail Package. I seem to …

  Welsh Corgi

  2 replies

  9 years, 1 months ago

  By: Welsh Corgi

• Best Strategy for Implementing (23) Incremental Table Loads

  Hi All, This is more a question of theory than a technical one, but here it goes. I need to mirror…

  Jerid421

  3 replies

  9 years, 1 months ago

  By: Jerid421

• SSIS package loses MessageSource in Send Email Task

  I'm modifying an SSIS package to send email if there is a validation error in the data. I have ever…

  tg 24698

  3 replies

  9 years, 1 months ago

  By: tg 24698

• Strange issue with basic SSIS Package

  I have a simple package that takes data from a SPROC and puts it in a .CSV file. Until today, it ra…

  planetmatt

  11 replies

  9 years, 1 months ago

  By: planetmatt

• Sage ODBC

  Hi I have a 32 bit ODBC connection configured in my connection manager to a sage DSN. I am trying t…

  spin

  8 replies

  9 years, 1 months ago

  By: spin

• Invalid Number of Result Bindings???

  I was very close to completing Part 4 of the Stairway to Integration Services series and when I ran…

  Jerid421

  5 replies

  9 years, 1 months ago

  By: Phil Parkin