SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• small help in ssis

  i have a dts package with 10 stored procs lik e exec stored proc1 exec stored proc 2 now i need …

  Chinna

  4 replies

  17 years, 4 months ago

  By: elegantkvc

• How to get the execution status programatically of each taskhost after a package is executed

  In 2000 DTS, I can retrieve the execution status by using Package.steps.item(index).ExecutionStatus…

  qq-522733

  2 replies

  17 years, 4 months ago

  By: qq-522733

• variable valueRemote path

  Can we provide a value like remote path to a variable (string) eg:\\bas02ndke3l\public\resultset.ou…

  chinni-652949

  6 replies

  17 years, 4 months ago

  By: Mukti

• Package Variable

  Hi Folks, I am retrieving a column of type XML from a table, this is part of the execute sql task: …

  ramdas.narayanan

  1 replies

  17 years, 4 months ago

  By: Crispin Proctor

• sql server 2008 has expired

  Hi, I had installed sql server 2008. today when i opened it, and it says it has expired. and go to …

  afgone

  8 replies

  17 years, 4 months ago

  By: Gail Shaw

• Copying data within the same database

  Hi All, I have the 'sql script' below joining data from 6 tables from 'Tables A' , am trying to cop…

  fosco-515896

  1 replies

  17 years, 4 months ago

  By: Crispin Proctor

• Check Execution Value

  I want to loop while another task in my package is executing? Any ideas?

  Kenneth Augustine

  1 replies

  17 years, 4 months ago

  By: Crispin Proctor

• Logging start of tasks

  Hi, currently my packages are logging errors and warnings. Additionally I would like to log (only!)…

  Tobias Kiemes

  2 replies

  17 years, 4 months ago

  By: Tobias Kiemes

• Importing Multiple Tables to Multiple Sheets of Excel using SSIS

  Hi, can u plz help me out in impoting multiple tables from a SQL server database to multiple she…

  Suneetha_k

  4 replies

  17 years, 4 months ago

  By: khelelo

• Dynamic message boby generation in Script Task

  Hi, Here I need to change the body of the email sent to result sets of the SQL query I am running. …

  mohan.mariyappa

  4 replies

  17 years, 4 months ago

  By: mohan.mariyappa

• Setting Variables in an Execute SQL Task and retrieving the results

  I'm trying to load a variable with the highest value in a column using the max function. I then wa…

  erabhan

  3 replies

  17 years, 4 months ago

  By: Mukti

• xls to sql

  Hi I m doing simple task in SSIS Source xls file ---> Destination SQL Server. Question 1. How ch…

  bang.prashant

  3 replies

  17 years, 4 months ago

  By: Crispin Proctor

• getdate column ssis

  Hi, i have a column in database that i set the datestamp using getdate(). when i load the data usin…

  afgone

  5 replies

  17 years, 4 months ago

  By: afgone

• writes null float data

  hi, so here is the problem: i have an excel file with a column as double-precision float [DT_R8](or…

  afgone

  2 replies

  17 years, 4 months ago

  By: afgone

• conversion from string to decimal

  I have a string column and need to map it with a decimal(12,2) column in SSIS package. Have tried u…

  swatianand83

  5 replies

  17 years, 4 months ago

  By: Jeff Moden