SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• 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

  16 years, 6 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

  16 years, 6 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

  16 years, 6 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

  16 years, 6 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

  16 years, 6 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

  16 years, 6 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

  16 years, 6 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

  16 years, 6 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

  16 years, 6 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

  16 years, 6 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, 6 months ago

  By: Thirumalesh

• Problems with DFT task in SSIS

  All, I am facing issues while trying to set a Data flow task in SSIS. I have a variable which holds…

  nikhil8960

  1 replies

  16 years, 6 months ago

  By: steveb.

• Convert GETDATE() to YYYYMMDD

  In derived columns i have to convert getdate() to YYYYDDMM. I dont need time. I want it in format l…

  rahulsony111

  20 replies

  16 years, 6 months ago

  By: Lynn Pettis

• Not able to run scheduled DTSX in SQL 2005

  I have created .DtsX File and Schedule on SQL 2005 Jobs, When i tryed to run mannaully its working …

  Arun-235202

  5 replies

  16 years, 6 months ago

  By: etrujillo 64790

• importing excel file to a table with ssis with 2 extra fields come from variable

  Hello All, I am new to SSIS. I wonder if I can get some help on this task: I am importing…

  raiders0724

  2 replies

  16 years, 6 months ago

  By: raiders0724