Integration Services

• Topics

  Started by

  Posts

  Last post

• Split column on Data Types

  Please assist? I would like to split column Event in two columns based on data types.

  yrstruly

  5 replies

  3 years, 6 months ago

  By: Thom A

• How to read URL which has PDF format in SSIS

  I Have a URL when we browse on the UI it open the PDF file. Here is the sample URL- https://abcirua…

  mcfarlandparkway

  1 replies

  3 years, 6 months ago

  By: Mr. Brian Gale

• Serious performance issue with our DR cloud site for iSeries AS400 ETL testing.

  We're doing a DR test and have ETL jobs that are running as much 2000% more duration with our DR cl…

  TangoVictor

  5 replies

  3 years, 6 months ago

  By: Jeff Moden

• Split string from SQL procedure results

  We are using an older version of SQL (2012 I believe) so I know that the SPLIT function is not avai…

  Brad Allison

  6 replies

  3 years, 6 months ago

  By: Jeff Moden

• Pivot Split Column

  Please assist. I would like to pivot a table, see ddl below. Also, split a column into five columns…

  yrstruly

  3 replies

  3 years, 6 months ago

  By: Thom A

• Pivot Split Column

  Please assist. I would like to pivot a table, see ddl below. Also, split a column into five columns…

  yrstruly

  1 replies

  3 years, 6 months ago

  By: Thom A

• Pivot Split Column

  Please assist. I would like to pivot a table, see ddl below. Also, split a column into five columns…

  yrstruly

  1 replies

  3 years, 6 months ago

  By: Thom A

• 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, 6 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, 6 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, 6 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, 6 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, 6 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, 7 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

  3 years, 7 months 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

  3 years, 7 months ago

  By: davidson02