SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Get Calling Task Properties in Event Handler Script

  I have a test package I'm working on with an execute sql task. on posteexecute I need to access the…

  mikefemenella

  7 replies

  15 years, 12 months ago

  By: sabyasm

• Execute SQL task with dynamic connection using dtsconfig file

  Hi All I have created each XML connection.dtsconfig file that located on my Test and and Prod serve…

  pcq0125

  7 replies

  15 years, 12 months ago

  By: sabyasm

• ISSUE WITH LOGFILE

  I have an SSIS package that writes to an XML log file whenever there is a package error. Is there …

  syamala.p

  1 replies

  15 years, 12 months ago

  By: sabyasm

• DataReader Source Vs OLE DB Source

  Hi, Can any one explain when to use DataReader Source and OLE DB Source ? and what is the differenc…

  Anamika

  4 replies

  15 years, 12 months ago

  By: sabyasm

• SSIS Package crashes with error on Error on 64 bit version of SQL Server 2005 SP3

  I have been getting dogged out all week with the following error: Error: Script could not be recomp…

  Welsh Corgi

  2 replies

  15 years, 12 months ago

  By: charlesc-1031022

• passing a SQL value into variable in SSIS

  Hi I have a SQL statement for example SELECT path from Servers where serverPath = 'FilePath' and I …

  pcq0125

  12 replies

  15 years, 12 months ago

  By: pcq0125

• Unable to cast COM object of type System.__ComObject to class type System.Data.SqlClient.SqlConnection

  I have a script task in the control flow where in I am connecting to the database (SQL Server 2005)…

  M Shah

  1 replies

  15 years, 12 months ago

  By: sarang

• Urgent! Assigning a value to SSIS package variables

  Hi, I am converting DTS to SSIS, in DTS there are 3 package global variables & dataflow task w…

  xparmanand

  2 replies

  15 years, 12 months ago

  By: xparmanand

• Unable to connect sybase database

  Hi, I need to take data from sybase database. I've dragged the OLE DB source and selected "Nativ…

  Venkatesan Prabu

  2 replies

  15 years, 12 months ago

  By: sidduhema

• Simple and weird problem in OLE DB source component

  hi i have a simple SSIS package which transfer data fro sql to mdb file today i added a new table …

  Bhuvnesh

  2 replies

  15 years, 12 months ago

  By: Bhuvnesh

• Problem scheduling SSIS package with Excel connection

  I have an SSIS package that uses an excel connection to drag data from an excel workbook. If I run …

  Jason Coleman

  1 replies

  15 years, 12 months ago

  By: chrisbarba-570443

• Data Flow Transactions

  I want to use a SQL Server Native Transaction in a package. I have a "data flow" that has an OLE DB…

  BSavoie

  1 replies

  15 years, 12 months ago

  By: sabyasm

• Getting null values for date and String columns(SSIS)

  Hi, I am using SSIS to extract data from excel sheet(Sample is attached). There are two columns. 1)…

  M_GREAT_4_SQL

  6 replies

  15 years, 12 months ago

  By: M_GREAT_4_SQL

• Parsing Problem

  I have this condition in my where clause CAST((SELECT SettingData FROM PropertySettings WHERE Setti…

  BSavoie

  1 replies

  15 years, 12 months ago

  By: wwei

• How to ignore columns when using union all

  Hi, I have written one ssis package in that i am getting data from two tables one from oledb source…

  jagadeeshb

  8 replies

  16 years ago

  By: Thirumalesh