SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• How to import data from sybase to sql2005 using ssis

  Hi All I am trying to import data from sybase to sql2005 by using ssis. But while establishing the …

  r_prasanna82

  7 replies

  17 years ago

  By: r_prasanna82

• SSIS issue when run with transaction

  Hello All, I am able to run SSIS package as an scheduled job when the transaction option is set to …

  TheMastermind

  8 replies

  17 years ago

  By: TheMastermind

• Loading Excel File into sqlserver table using SSIS 2005 package when number of columns in the excel file and the order of columns are not constant

  Hi, i have a problem in loading the excel file into a SQL-Server table using SSIS 2005 packa…

  prasanna-750812

  6 replies

  17 years ago

  By: stricknyn

• Problem with DTS.variables in script task

  Hi, I'm having a problem with the DTS.variables("MY_VAR").Value.ToString component in my script tas…

  Alistair Robertson

  1 replies

  17 years ago

  By: ab5sr

• doubt on ssis

  hi this is srikanth ,i am new to ssis i got one doubt in ssis i want to trasfer tha date using sor…

  srikanth125

  3 replies

  17 years ago

  By: SrikanthSv

• SSIS - how to send an email from data flow task for not matching data?

  Hi, I'm using SSIS - 2005 version. I want to send an email from Data flow task while matching the d…

  Raja Narendra

  1 replies

  17 years ago

  By: edmund chan

• CSV Export of Blob Data

  Hey, I need to export blob or text data to a csv file. The problem i am coming across is that this…

  paul.corujo

  4 replies

  17 years ago

  By: paul.corujo

• FTP SELECTED FILES ONLY using SSIS

  I am using SQL2008. But it shouldn't matter here. All I am trying is do is FTP files from remote se…

  SSISSSRSSSAS

  1 replies

  17 years ago

  By: bc_

• Strange behavior on Excel Connection when using Package Configuration

  I have a package that works perfectly. The beef of the package takes several tables and imports the…

  Jason Crider

  13 replies

  17 years ago

  By: Duane Douglas

• What is the best provider for iSeries?

  I want to transfer files from an iSeries running v5r3 OS. I know how to create an SSIS Data Flow t…

  Jim Covington

  3 replies

  17 years ago

  By: spaghettidba

• Performance - Handling large tables using Data flow task - SQL TServer 2005

  Hi, There is a large ( over 300 million ) table with lots of historical data and I need that to be …

  Vips-881281

  2 replies

  17 years ago

  By: vishal.gamji

• /CONFIGFILE ignored?

  Hi, I have a server (sql 2005 sp 3) and am using sql agent to run the package. I have specified th…

  edwardelliott

  4 replies

  17 years ago

  By: edwardelliott

• SSIS File Name with Periods

  Iam having my filename as "PR1.6_06-15-2009.xls" in the path. when i try to execute the file using …

  kkabdul

  4 replies

  17 years ago

  By: kkabdul

• Script task will run fine but doesn't execute the code

  All I am trying to do is copy a file to a different folder in a script task. Package 1 - I already …

  peterk1961

  2 replies

  17 years ago

  By: Phil Parkin

• Oracle Datatype compatibility with SQL SERVER 2005

  Hello , I am facing a strange problem when loading data from oracle to sql server 2005. Oracle Db;…

  Sasidhar Chandu

  5 replies

  17 years ago

  By: John Rowan