SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Help Passing a variable using OLE DB source

  I'm having trouble passing information from a variable to a query. I currently have 3 variable for…

  hogpen

  3 replies

  12 years, 3 months ago

  By: rhoskins

• IS IT POSSIBLE ?--NOT to CREATE Flat File If it is empty?

  I have a SSIS packages that does a SQL command on OLEDB Source and finds the records and outputs to…

  SSISSSRSSSAS

  16 replies

  12 years, 3 months ago

  By: ramkidec11

• Inserting new rows only from Excel to OLE DB Source

  I would like to add something to SSIS package, which will allow it to only insert rows that don't a…

  DVSQL

  5 replies

  12 years, 3 months ago

  By: Phil Parkin

• Invalid character value for cast specification

  I have a txt file with data as below: col1,col2,col3 NY,14319,9900 MA,14241,9900 CA,14358,Get WO NE…

  rockstar283

  6 replies

  12 years, 3 months ago

  By: Lynn Pettis

• Tip needed - Change Connection on several containers at the same time

  I have a DTSX package that I need to change the connections on for about 30 containers. Is there a…

  CptCrusty1

  5 replies

  12 years, 3 months ago

  By: COZYROC

• how to stop the package based on a condition?

  Hi, Based on the value of a variabale getting set, I want to stop my SSIS package (successfully) wi…

  Sachin Vaidya

  2 replies

  12 years, 3 months ago

  By: Pulivarthi Sasidhar

• create variable

  Hi I am trying to create a user defined variable using the parent UD variable. I am able to create …

  HBK_4700

  2 replies

  12 years, 4 months ago

  By: joeroshan

• Is this possible to accomplish thru SSIS?

  Hello guys, I have a process that we are trying to automate and we were wondering if we could use S…

  asm1212

  3 replies

  12 years, 4 months ago

  By: Phil Parkin

• SQL Task Fails - confirmed Connection and SQL is fine.

  I have a DTSX package that is a copy of another one. There are a lot of import steps so I thought …

  CptCrusty1

  5 replies

  12 years, 4 months ago

  By: CptCrusty1

• Setting Connection in Execute Package task

  I want to create a variable that sets the file path of the child SSIS package. In the Expression t…

  rs80

  2 replies

  12 years, 4 months ago

  By: rs80

• Difference between IsSorted and Sort transformation

  Hi Everyone, I have 2 data sources that get merged using a merge join. I set the IsSort property a…

  rs80

  4 replies

  12 years, 4 months ago

  By: rs80

• SSIS with PGP Encryption Failed when execute with SQL Server Job

  I developed SSIS Package with Execute Process Task which encrypt the text file into PGP encrypted f…

  hsmanandhar 33101

  9 replies

  12 years, 4 months ago

  By: Orlando Colamatteo

• Running package in a loop

  I have a pacakge that pulls the data from the table for a month. It runs on the first of the month …

  SQL_Surfer

  9 replies

  12 years, 4 months ago

  By: SQL_Surfer

• windows file system operation

  I am working on windows server 2003. I have a file 'target.file' at local. There is a 'target' fold…

  nzhang6666

  5 replies

  12 years, 4 months ago

  By: nzhang6666

• OLE DB Source -- SQL Command performance?

  The following question is based on my zero-understanding of how SSIS performs regarding the use of …

  peterzeke

  1 replies

  12 years, 4 months ago

  By: Orlando Colamatteo