SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Script Task Help Needed

  I am converting an ActiveX VBScript I used in SQL Server 2000 DTS to a VB.Net script for the Script…

  Robert W Marda

  4 replies

  18 years, 9 months ago

  By: Bill Scott

• Dynamically changing the connection for FTP connection Manager

  Hi, I have a table having different ftp url,user name, passwod, port no.I want to copy the file fro…

  Deepesh Verma

  2 replies

  18 years, 9 months ago

  By: njain_sh

• Can I Create And/or Modify SSIS Packages Using SQL Server Management Studio

  I know the interface for SSIS Packages is SQL Server Business Intelligence Development Studio. What…

  Robert W Marda

  7 replies

  18 years, 9 months ago

  By: Kathi Kellenberger

• Dynamic File Name

  I need to create a SSIS package where I will be loading data from a file which will be named as Fil…

  Jay Murthy

  3 replies

  18 years, 9 months ago

  By: Bill McDonough

• Populating DateTime variable from Execute SQL task

  Please help! I am designing an SSIS package and need to change the value of a DateTime global varia…

  Ulysses Bear

  3 replies

  18 years, 9 months ago

  By: Iordan Slavov

• Is it possible to use SSIS to disable jobs on multiple servers?

  I would like to use SSIS to enable/disable jobs during holidays.  Here's my plan... 1.&nb…

  John-79567

  1 replies

  18 years, 9 months ago

  By: andrewkane17

• Flat File Destination

  Is there any way to control the column order on the output to a flat file? It seems to want to orde…

  cprice79

  1 replies

  18 years, 9 months ago

  By: michanne

• SSIS Import/Export Wizard does not create primary keys on new tables (lost feature)

  I've found that the new SSIS Import/Export Wizard does not create primary keys on new tables that i…

  Ryan-209402

  3 replies

  18 years, 9 months ago

  By: Tim Goldstein-368444

• need help Installing SSIS

  Hi , I have installed SQL Server 2005 Express Edition onto my system and now i would like to instal…

  pinky

  3 replies

  18 years, 9 months ago

  By: debrucer1

• Basic Question

  I'm used to the old DTS way of doing things where the console would count up the number of records …

  Terry Gamble

  1 replies

  18 years, 9 months ago

  By: MarkA-218060

• SSIS @[System::ErrorDescription]

  Hello, I would like to get the value of System variable "ErrorDescription" in a table, by implement…

  DONG YEN

  1 replies

  18 years, 9 months ago

  By: d_george

• Issues in migrating SQL 2000 DTS To SQL 2005/SSIS (Microsoft.SqlServer.SmoEnum)

  PLEASE IGNORE THIS POST. MODERATORS.. KINDLY DELETE THIS THREAD AS THIS IS A DUPLICATE BY MIST…

  CDBA

  1 replies

  18 years, 9 months ago

  By: CDBA

• Parameterized SQL Commands

  AARGH! I am at my wit's end. I have searched documentation, Online SQL, this forum, MS, Google, ETC…

  Michael Lee-169622

  3 replies

  18 years, 9 months ago

  By: Iordan Slavov

• Transfering data trigger problem

  I have set up an integration package to transfer a number of tables. One of the destination tables …

  Terry300577

  2 replies

  18 years, 9 months ago

  By: Joshua M Perry

• Binary numeric field in a MVS flat file

  Hello I need to read a flat file comming from a MVS Host. It contains an EBCDIC text (this is not a…

  Victor YAMMOUNI

  1 replies

  18 years, 9 months ago

  By: alex0603