SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS Package in Metadata?

  Is there a way to save a SSIS package in metadata instead of saving as dtsx file? Advance thanks...…

  Jayakumar Krishnan

  2 replies

  10 years, 11 months ago

  By: bbrewer 62909

• Load data using Oracle SP in SSIS

  Hi, I am very new to SSIS. I want to load data using an oracle stored procedure to a SQL server dat…

  josefrancis

  4 replies

  10 years, 11 months ago

  By: nishav2

• Using Script Task to check if Folder Exists

  I am creating a new directory/folder in my package, but before I do that I want to check if the dir…

  mrtrich99

  12 replies

  10 years, 11 months ago

  By: berokke1

• Table Valued Function in SSIS

  Hi I have a table values function and i would like to use the function in SSIS package OLEDB Souce …

  chinni-652949

  5 replies

  10 years, 11 months ago

  By: michiel.matthijssen

• Problem with Unicode data type DT_NText

  I am new to SSIS and using Sql Server 2008 SSIS package. The package read the data from one of the …

  Karan_W

  5 replies

  10 years, 11 months ago

  By: Koen Verbeeck

• How to add Dynamic column in the Flatfile Source?

  Hi Friends, Actually i have Flatfile as a TXT files .In that i have 100 Columns and i need to impor…

  arunnrj87

  37 replies

  11 years ago

  By: Phil Parkin

• What's the equivalent "Multiphase Data Pump" in SSIS?

  hi to all I'm migrating a package from DTS to SSIS 2005. A DTS package performs a data transfer fro…

  previn1980

  4 replies

  11 years ago

  By: previn1980

• Derived Column to handled mulitple conditions in CASE statement?

  HI, I've got a case statement that works, but because I have to do it in SSIS I am at a loss: ---th…

  KoldCoffee

  16 replies

  11 years ago

  By: Andre 425568

• Moving multiple files to archive folder SSIS 2005

  I have a SSIS package that moves .xls files from one directory to and archive folder. This works pe…

  Lord Slaagh

  2 replies

  11 years ago

  By: Lord Slaagh

• Parse out the first 3 characters

  Hi how do I do I pull out the first three chars of a column using a derived column. I need to pull …

  ronan.healy

  15 replies

  11 years ago

  By: MMartin1

• SSIS Help..

  Hi Guys, Need help in SSIS. Here is source looks like Sample Source Data .xlxs file Add, New, Pro…

  rocky_498

  6 replies

  11 years ago

  By: Eirikur Eiriksson

• create a SSIS package which will call the stored procedure and dump the output of the procedure into table

  I want to create a SSIS package which will call the stored procedure and dump the output of the pro…

  Karan_W

  8 replies

  11 years ago

  By: seddy2765

• Excel Source in SSIS

  Hi All, I have very simple SSIS Package, ready data from Excel (.xlsx) and transfer into SQL. From…

  rocky_498

  4 replies

  11 years ago

  By: rocky_498

• SSIS DTSX Package Run bat file to FTP

  I have a step in my dtsx package that executes a batch file. The batch file compresses files into a…

  ldgiidev

  1 replies

  11 years ago

  By: ldgiidev

• Excel Connection Manager in SSIS Help

  Hi Guys, I need urgent help. I am working on project where I am going transfer all .XLS file forma…

  rocky_498

  13 replies

  11 years ago

  By: rocky_498