Integration Services

• Topics

  Started by

  Posts

  Last post

• Very wierd casting exception after deployment

  Hey everyone,   The issue I'm having is the strangest thing so I figured I post it here to get…

  stricknyn

  3 replies

  3 years, 11 months ago

  By: Phil Parkin

• Dts Runtime Disabling Tasks At runtime.

  Hi, We have a requirement to disable Data Load Tasks at runtime, this is a large package and if one…

  Simon Hundleby

  6 replies

  3 years, 11 months ago

  By: Simon Hundleby

• SSIS Transfer data from one sql server to another sql server(Server to local)

  Hi All, My table size is 80GB. In that table one column is XML when i transfer the table from serve…

  polo.csit

  8 replies

  3 years, 11 months ago

  By: Eirikur Eiriksson

• Spawning multiple copies of the same SSIS Package

  Hi all   I'll explain this as best I can but I've no doubt I'll miss something so feel free to…

  richardmgreen1

  10 replies

  3 years, 11 months ago

  By: richardmgreen1

• Creating Primary Column(Key) & Remove Duplicates

  Please advise, how do i create a primary key column when there is none(not even a column with uniqu…

  yrstruly

  12 replies

  3 years, 11 months ago

  By: Thom A

• Match and No Match(Gives same output)

  I would like to match this source table: CREATE TABLE [dbo].['TMI Sites $']( [Advertiser] [nvarchar…

  yrstruly

  8 replies

  3 years, 11 months ago

  By: Sergiy

• Issue with Execute SQL Task in Sequence container returning 0 results

  I'm working on a package to update some local tables from a datalake we access. I've been able to w…

  SoDakDave

  6 replies

  4 years ago

  By: SoDakDave

• C# String.Split() using a multi-character delimiter in a script task

  I have a requirement to split input data into multiple columns, but the data is delimited by multip…

  Pete Bishop

  5 replies

  4 years ago

  By: davidson02

• Exporting Data to Excel File with Yesterday's Date

  I'm exporting data to an Excel file and adding the date to the end. But I'd like the date to be the…

  callen-557064

  2 replies

  4 years ago

  By: callen-557064

• Accessing variables dynamically

  I have an SSIS package which updates a number of tables and sets a variable upon success. I'd need …

  Pete Bishop

  7 replies

  4 years ago

  By: Pete Bishop

• Loading x number of CSV files into x number of unique tables of a database

  Hi, This is my first time here so hope I am posting this at the right place. I recently started a n…

  masterelaichi

  52 replies

  4 years ago

  By: masterelaichi

• Upgraded DLL reference

  I have an SSIS package which uses dotConnect for MySQL - currently using the 130 DLL. We're migrati…

  Pete Bishop

  1 replies

  4 years ago

  By: Pete Bishop

• How can I execute OLEDB Command without Result Set

  I am working with an application that has many INSERT and UPDATE stored procedures for our tables. …

  Owen White

  10 replies

  4 years ago

  By: Owen White

• SSIS ForEach Loop never ends, next task executes

  I have built an SSIS package that imports files with xml data into an SQL table. There are 16K file…

  alicesql

  4 replies

  4 years ago

  By: alicesql

• Copy or Export Packages from SSISDB to Files

  Greetings. I'm trying to export or copy existing integration packages from an SSIS Catalog. One of …

  callen-557064

  3 replies

  4 years, 1 months ago

  By: callen-557064