Integration Services

• Topics

  Started by

  Posts

  Last post

• Script task file check error

  Hi , In my SSIS Package I am using Script task to check whether file exists or not. I am having 3 v…

  vipin_jha123

  2 replies

  11 years ago

  By: Lowell

• Send Mail Task error

  Hi, In my Package I have placed the Send mail task on package level on post execute event, my packa…

  vipin_jha123

  1 replies

  11 years ago

  By: saravanan.soundarrajan

• (re)Generating SSIS packages progamatically but keeping GUIDs for working with source code control

  Hi Guys, I am looking for some general advice, although if anyone has specific code I would love to…

  aaron.reese

  3 replies

  11 years ago

  By: Phil Parkin

• error redirection does not work with excel data source in ssis 2012

  Hi everyone, I am using ssis 2012 to import data from excel 2007 in to sql server using oledb desti…

  sej2008

  3 replies

  11 years ago

  By: sej2008

• Design Pattern for Flat File Import Data Corruption (Bad Data Type)

  What is the best way in SSIS to handle records that fail due to improper formatting inflat file loa…

  Chad.Kemp

  3 replies

  11 years ago

  By: Chad.Kemp

• SSIS Derived Column Transformation

  Hi everyone I am trying to figure out how to parse a specific string od fata out of a column in ssi…

  Scubba-Steve

  11 replies

  11 years ago

  By: Scubba-Steve

• Can anyone shed some light on the following problem SSIS package run from sql server agent job(SSIS 2008 R2 excell connection error)

  OK,the following issue has occured in a job that is supposed to run at the last day of each month,i…

  Resender

  1 replies

  11 years ago

  By: Resender

• Passing parameter to Execute sql task

  Hi I have one temp table as shone below having data with bigint data type In temp table there rae …

  vipin_jha123

  1 replies

  11 years ago

  By: Eirikur Eiriksson

• Cannot see configuration file when creating a SQL Job for SSIS

  SQL 2008 R2 I have an SSIS package called MyXML I need to schedule this job using the sql agent. I…

  GF

  1 replies

  11 years ago

  By: GF

• How to build in SSIS

  I need to fetch data from one SQL server to other SQL Server. One solution is to create linked serv…

  sqlinterset

  13 replies

  11 years ago

  By: SQLRNNR

• SSIS 2012 Oledb script component

  Hello, I'm stuck at implementing the code found at oledb in script task[/url] for use in a script c…

  Jo Pattyn

  3 replies

  11 years ago

  By: Jo Pattyn

• TransactionOption issue

  Hi Team I have a SSIS package which has lot of tasks like for loops, sql tasks etc. When I set Tra…

  GonnaCatchIT

  1 replies

  11 years ago

  By: kferrara

• SSIS Jobs Failed

  Hi , I have created simple package loading data from source to destination. in BIDS working fine, b…

  vipin_jha123

  1 replies

  11 years ago

  By: Jo Pattyn

• Select data from flat file to sql table

  Hi, I have TXT file in below folder H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Loading_Geograp…

  vipin_jha123

  4 replies

  11 years ago

  By: John Mitchell-245523

• Slowly Changing Dimensions

  Hi guys, Delving into the world of SSIS now and having some fun with SCD's. Particularly around NV…

  charic

  3 replies

  11 years ago

  By: SQL.AP