SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• How to create a Transaction Commit/Rollback for Oracle DB in SSIS

  I'm able to connect to the Oracle database to insert the data into multiple tables using OLEDB conn…

  loi-497816

  8 replies

  17 years ago

  By: bluepaperbags

• SSIS dataextraction from GBase & Universe datasources

  I have started to use SSIS lately and i need to know if it can extract data from GBase and Universe…

  samerh

  1 replies

  17 years ago

  By: COZYROC

• Event Handlers in SSIS

  hi, i set an event handler for one task in my package. but event handler is not working. i tried wi…

  mamsay

  1 replies

  17 years ago

  By: Mukti

• Problem trying to cmdshell a 32bit SSIS package - 8 char

  My problem is that when I try to xp_cmdshell a 32bit SSIS package, it is using the 8dot3 file forma…

  Will1922

  4 replies

  17 years ago

  By: Will1922

• Configure memory for Integration Services service and monitor current use of memory by SSIS

  Apologies if this has been asked before, but I have the following 2 questions: (1) How can I find o…

  Marios Philippopoulos

  4 replies

  17 years ago

  By: Marios Philippopoulos

• DTExec set command doesn't work for specific string but others are fine...what's so special about this one?

  Hello folks - this one is driving me potty, been at it for hours. DTExec script setting some global…

  jonathan.strauss

  1 replies

  17 years ago

  By: jonathan.strauss

• problem with Excel in SSIS

  Hi all, I am trying to get the file load from SSIS package btu the problem si i have file with firs…

  pat-261672

  13 replies

  17 years ago

  By: steveb.

• FTP TASK in SSIS

  Hello There, I'm new to SSIS and i want to run a FTP task in SSIS.Basically I want to transfer some…

  nalin_abeywardana

  7 replies

  17 years ago

  By: nalin_abeywardana

• Email reports from SSRS to users via SSIS

  Hi, We have a number of reports created in SQL Server Reporting Services, and I'd like to email the…

  samalex

  1 replies

  17 years ago

  By: Mukti

• change the unformat data into format

  Hi SSIS gurus, i have a problem.i have a flat file source, in that 7 columns are there. the final c…

  muralikrishna37

  1 replies

  17 years ago

  By: Mukti

• expression issue

  I wrote a query in the Expression window but I get an error msg when I try to preview it with the O…

  bluepaperbags

  4 replies

  17 years ago

  By: Jack Corbett

• Reading and acting on Success/Failure constraints in SSIS

  Hi all. If yo've read my previous post, you'll know that I'm in a situation where I need to check …

  sharon.bender

  2 replies

  17 years ago

  By: sharon.bender

• Import Data From Excel to SQL SERVER 2005

  Hi all, I need to do a SSIS package,which imports data from excel to sql server database,which shud…

  bharathi-903755

  2 replies

  17 years ago

  By: SSIS New Developer

• Rolling Up and Ranking Faster: Aggregate Transformation or SQL Procedure?

  Hey Gang, I have to do a host of roll ups on sales fact data. In SSIS which have you found to fas…

  omhoge

  3 replies

  17 years ago

  By: omhoge

• weird error occured while transferring SQl table intoAccess file

  hi i m having SQL server 2005 Any weird error occured while transferring SQl table into Access fi…

  Bhuvnesh

  3 replies

  17 years ago

  By: Jack Corbett