SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Upgrade SSIS 2005 to SSIS 2008

  I install SQL Server 2008, When I opend my SSIS Project (Which is build in SQL Server SSIS 2005). I…

  saurabh.deshpande

  17 replies

  10 years, 11 months ago

  By: Koen Verbeeck

• SSIS Web Services Task question

  I am new to SSIS and trying to add a variable to the Web Service Task Input section. In the "Enter…

  Alan Lewis

  4 replies

  10 years, 11 months ago

  By: MMartin1

• SSIS not importing all of Excel file

  I've got an Excel source and OleDB Destination set up. The SSIS package runs, but I only get 23591 …

  nonghead-webspam

  14 replies

  10 years, 11 months ago

  By: MMartin1

• Conditional Split 1 1 1 1

  i have the following code in my conditional split ((TRIM(INV_SECTYPE_COD) == "70")) && ((TRIM…

  ronan.healy

  6 replies

  10 years, 11 months ago

  By: herladygeekedness

• SSIS 2005 package connecting to a Sql Sever 2012 data source

  Can a SSIS 2005 package connect to a Sql Server 2012 database? I'm not getting it to work. I even…

  rburko

  3 replies

  10 years, 11 months ago

  By: rburko

• (SSIS 2012) Excel Destination Columns Added After Data Flow Task Already Designed

  Working on an SSIS 2012 project for a client. The project basically finds and loops through a bunch…

  brad.mccollum

  3 replies

  10 years, 11 months ago

  By: MMartin1

• dervied box

  i need to do the following If Fund Complex = “Russell” and INV_SECTYPE_COD equal to ’75’ iii. Notio…

  ronan.healy

  6 replies

  10 years, 11 months ago

  By: herladygeekedness

• DtsDebugHost.exe

  Can some one please tell me what DtsDebugHost.exe is used for?

  A Little Help Please

  1 replies

  10 years, 11 months ago

  By: narla.veerababu 32799

• create query

  i have this create this query DECLARE @SqlStmt NVARCHAR(max), @WorkingAttributeTableName NVARC…

  ronan.healy

  6 replies

  10 years, 11 months ago

  By: ronan.healy

• import data from xml using ssis

  Using Sql Server 2012 STD edition, SSDT (Visual Studio 2010 shell, .net framework 4.0.3 SP1 I am tr…

  ForumUser3

  1 replies

  10 years, 11 months ago

  By: COZYROC

• problems checking for files in SSIS

  I took at look at this component: http://www.sqlis.com/23.aspx and it's causing the same issue as t…

  Matthew Cushing

  4 replies

  10 years, 11 months ago

  By: Florian Schmidt

• Bulk Insert

  Hi All - What I am looking to do is use a Bulk Insert to import a cvs file to a table. This table i…

  scott.barnett

  5 replies

  10 years, 11 months ago

  By: Ed Wagner

• Question related to Identity column

  I have a SOURCE table as below in Prod: SELECT '-1' as PKey, NULL as ID, 'Unknown' as Name UNION SE…

  rockstar283

  13 replies

  10 years, 11 months ago

  By: Eirikur Eiriksson

• Ssis error: object not set to a valid object type

  I have a for each container that is enumerating inside excel files. I have a file system task insid…

  ayazniazi

  3 replies

  10 years, 11 months ago

  By: Eirikur Eiriksson

• Could not load package "package name" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E14 (Only the owner of DTS Package 'package name' or a member of the sysadmin role may create new versions of it.). The SQL statement that was issued

  I have a package and within that package I am executing another package using the Execute Package T…

  ayazniazi

  2 replies

  10 years, 11 months ago

  By: ayazniazi