Integration Services

• Topics

  Started by

  Posts

  Last post

• Getting the first of the month based on yesterday's date

  Hi All, I have tried several things and it's not doing quite what I need it to. So I have this expr…

  Kazmerelda

  10 replies

  9 years ago

  By: Phil Parkin

• SSIS Package Execution Error: Exception has been thrown by the target of an invocation

  My SSIS project, developed in Visual Studio 2012 under my Windows user account, includes two packag…

  jay-125866

  3 replies

  9 years ago

  By: Phil Parkin

• Connect Oracle Source

  Dear Folks, I am trying to connect Oracle source using .Net Providers\Odbc Data Provider. it shows …

  Kannan Vignesh

  2 replies

  9 years ago

  By: Kannan Vignesh

• connection manager time of day configuration

  Microsoft Visual Studio Premium 2012 Version 11.0.61219.00 Update 5Microsoft .NET Framework Version…

  jonathan.matt

  13 replies

  9 years ago

  By: jonathan.matt

• Moving data from Excel file with different name to SQL table using SSIS

  Hi, Am new to SSIS. i have a requirement. Everyday Excel file will be uploaded into one folder with…

  Helpseeker

  5 replies

  9 years ago

  By: Thom A

• Where is the Immediate window hidden in SSIS script task > vb.net ?

  Is there a way to display the Immediate window (MSDN's mention of Debug > Windows > Immediate…

  isaac_654135

  1 replies

  9 years ago

  By: Phil Parkin

• Script task vb.net - how to advance one line at a time

  Is there a way to advance just ONE line of code at a time (not run to cursor, not run to the next b…

  isaac_654135

  1 replies

  9 years ago

  By: Phil Parkin

• Splitting a "Yearly" Forecast Record out into 12 "Monthly" Forecast Records

  I have an SSIS package that currently outputs this dataset:  Some records represent Forecast …

  Jerid421

  1 replies

  9 years ago

  By: Phil Parkin

• SQL SERVER 2008 SSIS Package not working with sql server 2014 database

  Hi,I have ssis package on sql server 2008 which use "Transfer SQL Server Objects Task". It works fi…

  faiz_ku

  2 replies

  9 years ago

  By: faiz_ku

• Base multiple queries on result from data flow

  This seems like it should be simple, but I can't seem to find the answer. I have a multiple table q…

  palandri

  3 replies

  9 years ago

  By: Phil Parkin

• Get SQL-Statement at Runtime

  Hi,Is it possible to output the SQL statement (from Table/View or DirectInput) at runtime from a Da…

  info 58414

  1 replies

  9 years ago

  By: John Mitchell-245523

• Issue with code in script task

  I have this piece of code in script task when the package is running It will check for SDB database…

  mcfarlandparkway

  2 replies

  9 years ago

  By: mcfarlandparkway

• Using Variables at package level

  Can we create a variable at package level and set default value as query string I mean Name as Tabl…

  mcfarlandparkway

  4 replies

  9 years ago

  By: Thom A

• SQL Server Agent: Deploying a job mid-execution - Effects

  Hello all, I have one specific question, but please feel free to include as much related informatio…

  reelnoncents

  7 replies

  9 years ago

  By: happycat59

• Need some direction - SSIS package 2008R2

  I have never developed a full fledged SSIS package ( been DBA for quite some time , never had to de…

  curious_sqldba

  1 replies

  9 years ago

  By: Marc Beacom