Integration Services

• Topics

  Started by

  Posts

  Last post

• Bulk insert failure with Foreach Loop container

  I am currently trying to import multiple txt files into a database using a bulk insert task and a f…

  eseosaoregie

  1 replies

  13 years, 11 months ago

  By: eseosaoregie

• Decimal and Flat File as desitination and scale not working

  Hi, I have a flat file in data flow task that is a desintation. I have a flat file connection obj…

  smond

  2 replies

  13 years, 11 months ago

  By: Raunak Jhawar

• dts and ssis

  Hi Friends, Few questions on DTS and Integration Services Q1)Why SSIS service is only one instance …

  Oracle_91

  8 replies

  13 years, 11 months ago

  By: Elliott Whitlow

• very strange error Oracle CLOB type

  Hi, Here is the problem: Oracle source table with CLOB. SQL 2008 destination table. Using SSIS. 1. …

  kevin bacon

  1 replies

  13 years, 11 months ago

  By: kevin bacon

• SSIS Deployment Session

  Hi Experts, I have been asked to give a session on SSIS Deployment.I dont know what are all the thi…

  VastSQL

  5 replies

  13 years, 11 months ago

  By: Raunak Jhawar

• Data Profile Task

  Hi, Data Profile Task is very useful for analysis. But it only accepts ADO.NET connection. What sho…

  Raunak Jhawar

  6 replies

  13 years, 11 months ago

  By: stevefromOZ

• I want to schedule an email daily using SSIS writing couple of queries

  I want to schedule an email daily from database having result set of the query : SELECT categorynam…

  biren

  6 replies

  13 years, 12 months ago

  By: alen teplitsky

• Connection string being passed into DTEXEC is not used during execution of package

  (I apologize that this is posted in a different (wrong) section of the forums, but I can't figure o…

  gvaldridge

  1 replies

  13 years, 12 months ago

  By: gvaldridge

• SSIS job doesn't find connections at runtime

  Hi. I have created an SSIS package in BIDS which pulls data from Sybase to SQL 2008. This works fi…

  CraigIW

  4 replies

  13 years, 12 months ago

  By: CraigIW

• Need example to execute stored procedure using script task.

  Hi, I am migrating SQL server 2000 DTS packages to SSIS packages. I am new to this. I have ActiveX …

  Kari Suresh

  7 replies

  13 years, 12 months ago

  By: Kari Suresh

• Error: An OLE DB error has occurred. Error code: 0x80040E21.

  Hi ALL, I have a ssis package which pulls data from sybase 9 ASA to sql server 2005. In the package…

  srinivas govada-475328

  1 replies

  13 years, 12 months ago

  By: CraigIW

• SSIS Connections managers Update at Runtime

  Hello, I need to update the connection string (ServerName) of my OLEDB Connection. I've got on Sp t…

  Miguel Costa

  1 replies

  14 years ago

  By: applebynick

• Multiple instances of the same destination table in a single data flow

  Hello, Here is the situation: there is a package in collection that over time has grown over time t…

  padre

  5 replies

  14 years ago

  By: Koen Verbeeck

• Error when running Execute SQL Task

  Hi, I had migrated DTS 2000 package to SSIS package. I am getting the following error While running…

  Kari Suresh

  2 replies

  14 years ago

  By: Kari Suresh

• SSIS FileSystem Task Catch Error

  I've a file system task that is in a foreachloop container that moves log files to archive share, o…

  Djcarpen11

  1 replies

  14 years ago

  By: Elliott Whitlow