Integration Services

• Topics

  Started by

  Posts

  Last post

• Cannot Convert between unicode and non-unicode string data types

  I"m trying to learn SSIS and am creating a package. I have a data flow with the following: 1. OLE D…

  maria.lindquist

  1 replies

  9 years ago

  By: Martin Schoombee

• SSIS Script Task if Variable RecordCount >0 Fail Package

  I need to create a VB Script Task if the Variable RecordCount >0 Fail Package if not succeed. I…

  Welsh Corgi

  10 replies

  9 years ago

  By: Lowell

• Parallel Processing using C# in a SSIS 2012 Execute Script Task for calling multiple DTSX packages stored at DTS or File System

  Hi Gents, I have landed into a scenario where we have around 60 to 70 SSIS packages that would be l…

  anupam.jha

  5 replies

  9 years ago

  By: Phil Parkin

• Performance Finger pointing: suggestions on next steps.

  I've got a package that does ETL from a server over VPN to something local; If i run the package o…

  Lowell

  5 replies

  9 years ago

  By: mister.magoo

• IF Exist Delete file and copy a Template File VB.NET Script Task

  I'm trying to remember how I would check for the existence of a file and Delete it in a VB Script T…

  Welsh Corgi

  8 replies

  9 years ago

  By: Lowell

• IF Exist Delete file and copy a Template File VB.NET Script Task

  I'm trying to remember how I would check for the existence of a file and Delete it in a VB.NET Scri…

  Welsh Corgi

  7 replies

  9 years ago

  By: Jeff Moden

• Copy File in SSIS using VB.NET

  I'm trying to copy a Template File to another folder. There is an issue with the last line of code.…

  Welsh Corgi

  4 replies

  9 years ago

  By: Welsh Corgi

• Change the Language for SSIS Script Task

  How can I change the OOP language that SSIS uses for things like the Script task? Mine comes up to …

  AndrewSQLDBA

  11 replies

  9 years ago

  By: Welsh Corgi

• SSIS defaults to C# on a script task -- Need VB.NET

  SSIS defaults to C# on a script task I Need VB.NET but I'm having trouble changing the syntax of th…

  Welsh Corgi

  1 replies

  9 years ago

  By: Lowell

• Importing Excel file - Overriding the ACE driver's field type

  Hi All, I know this is an age old problem, however, does anyone know how to get around the ACE driv…

  Thom A

  12 replies

  9 years ago

  By: Phil Parkin

• SSIS Process only the "Latest" file based on name

  I've got a situation where csv files are superseded by another in a given month; they gather on an…

  Lowell

  7 replies

  9 years ago

  By: Phil Parkin

• 7 zip creating an additional folder named "+"

  Hey guys, I'm using an execute process task to unzip a password protected zip file. I'm able to unz…

  dndaughtery

  2 replies

  9 years ago

  By: dndaughtery

• Unable to map an environment variable with the sensitive property set to True

  Hi, I am getting the error below from the SSIS package scheduled from a SQL agent job . Locally th…

  PSB

  3 replies

  9 years ago

  By: Phil Parkin

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

  Good Evening ladies and Gents, I am getting the error message below within an SSIS package that i …

  waxb18

  1 replies

  9 years ago

  By: waxb18

• Get all the SSIS packages under Integration services catalog t sql

  Hi Experts, If I need to list out all the SSIS packages under the Integration services catalog fol…

  SQL_Hunt

  5 replies

  9 years ago

  By: SQL_Hunt