Integration Services

• Topics

  Started by

  Posts

  Last post

• Can't import packages to IS

  Here's a weird one: I connect to Integration Services on Sql Server 2008 R2. I right-click on MSDB…

  g.britton

  1 replies

  11 years, 1 months ago

  By: g.britton

• Can connect to AS/400 with IBM OLEDB Provider for DB2, but can't get OLEDB Destination to work with it

  I'm currently trying to be able to set up an SSIS package which runs a stored procedure in AS/400 a…

  giselle.aldridge

  1 replies

  11 years, 1 months ago

  By: giselle.aldridge

• Compare DATETIMES from AS400 to SQL Server via SSIS Variable

  I have an AS400 table where the DATE (YYYY-MM-DD) is separate from the TIME (HH24:MM:SS). I pul…

  paul.j.kemna

  3 replies

  11 years, 1 months ago

  By: Phil Parkin

• Calling Windows Environment variable into the Master package in Project Deployment model

  Hi All, I am somewhat got used to the SSIS packages, and at one location i got struck and i nee…

  Guitar_player

  35 replies

  11 years, 1 months ago

  By: Lempster

• SSIS Ignoring Script Task When Package Deployed to SQL Agent

  I have an SSIS project that works fine in Visual Studio (VS 2008). But when I deploy it to SQL Serv…

  grant.owens

  5 replies

  11 years, 1 months ago

  By: Mark Underhill

• Getting random LCK_M_SCH_M on convert and bulk insert task

  I starting getting random LCK_M_SCH_M locks with huge wait time, which hung my etl proccess. The ss…

  elias.stassinos

  2 replies

  11 years, 1 months ago

  By: elias.stassinos

• SSIS Ignoring Script Component

  Hi All. I am at my wits end with this problem. I have a flat source file followed by a derived Colu…

  Tim ffitch

  3 replies

  11 years, 1 months ago

  By: grant.owens

• How to Evaluate Date Comparison Between 2 Columns & Send Email?

  I'm working on a project for a client where SSIS handles automated daily imports of numerous Excel …

  brad.mccollum

  2 replies

  11 years, 1 months ago

  By: brad.mccollum

• Running file tasks on a remote server accessed via RDP

  Its Friday so I am doing some blue sky thinking... I have just started a new role where we have abo…

  aaron.reese

  2 replies

  11 years, 1 months ago

  By: aaron.reese

• Slowly Changing Dimension- Choking on large Row count

  Hello I am using SSIS 2012 SDT and I am trying to use the Slowly Changing Dimension Transformation.…

  jameslauf

  5 replies

  11 years, 1 months ago

  By: Martin Schoombee

• how to read contents of flat file in SSIS and extract from it just one value for use in variable?

  From the attached txt file, I need to be able to extract the rowcount for the file having the name…

  KoldCoffee

  25 replies

  11 years, 1 months ago

  By: KoldCoffee

• Compare two like tables on different servers then update missing data

  I am looking to implement an SSIS package that will go out to our ERP database server, grab specifi…

  cstg85

  9 replies

  11 years, 1 months ago

  By: Martin Schoombee

• Update Script component on fly

  Hi, In my SSIS Project I am using Script component, below is the code. I am referring 100 of table …

  vipin_jha123

  1 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• no more free (proper) SCD Task for 2012?

  HI all, I just came across this interesting Codeplex SSIS Task to handle Slow Changing Dimensions: …

  Eric Mamet

  4 replies

  11 years, 1 months ago

  By: Eric Mamet

• 3rd party data edits through OLE DB Commands or in one Stored Procedure

  We have data that comes from a 3rd party in an Excel spreadsheet. We have successfully loaded that …

  ITBobbyP85

  1 replies

  11 years, 1 months ago

  By: Nevyn