Stack Overflow
Stack Overflow

Questions tagged [ssis-2005]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2005 is a part of SQL Server 2005 business intelligence platform.

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. wikipedia

35 questions
13
votes
1 answer

How to add new columns to Flat File conn in SSIS without resetting data types for existing cols

SSIS 2005 I have a flat file connection which is the result of a db dump. New columns have been added to the file and now they need to be added to the connection manager. There are a lot of columns and not all of them have the default dataypes How…
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
5
votes
2 answers

Strange behavior with uri and WebClient classes on SSIS package

I have a quite strange situation. I have this very simple package: Task "get list" retrieves a data table from an assembly with one column and a list of URL to be ran into a object variable. The "foreach" loop loops through the object variable and…
Diego
  • 34,802
  • 21
  • 91
  • 134
4
votes
1 answer

select data from excel spreadsheet that's read only

I've got a dtsx package that selects data from an excel spreadsheet on the network and inserts it into a sql server table twice a day. However, the process fails if someone is in the spreadsheet modifying data. Is there a way to select data from…
DForck42
  • 19,789
  • 13
  • 59
  • 84
3
votes
1 answer

Script Editor won't open or change language in SSIS 2005

I have a task which creates a SSIS package using BIDS 2005. There are 2 problems when I work with BIDS 2005, but don't occur in BIDS 2008. Default language in Script Editor is Visual Basic (I prefer C#). When I click on the Design Script button, it…
QuachNguyen
  • 131
  • 11
2
votes
0 answers

How do I manage line-endings when reading XML file in SSIS 2005

I have a simple xml file. It defined an element in that file as... I…
BlackMael
  • 3,198
  • 5
  • 25
  • 42
2
votes
1 answer

Overriding package configured variables in SSIS 2008 using DTEXEC /SET

I'm having a problem transitioning a 2005 package to 2008 - it appears that in 2008, package variables configured to use a Configuration Filter (eg populate from [SSIS Configurations]) will not honor the /SET command provided by dtexec.exe to…
manning18
  • 957
  • 3
  • 8
  • 18
2
votes
1 answer

Cannot open a Script Task, but only one specific SSIS package, any suggestions please?

For only one particular SSIS package (v. 2005) I am getting the following error when trying to open the script task... TITLE: Microsoft Visual Studio Cannot show the editor for this task. ADDITIONAL INFORMATION: The operation could not be…
DazSheps
  • 21
  • 2
2
votes
2 answers

SSIS 2005 Can Merge Join accommodate one-to-many joins

I have a Data Flow Task that does some script component tasks, sorts, then does a Merge Join. I'd like to have the Merge Join do the join as a 1-many. If I do an Inner Join, I get too few records: If I do a Left Outer Join, I get WAY too many…
JFV
  • 1,803
  • 6
  • 24
  • 38
2
votes
1 answer

How to open file which is stored under Miscellaneous folder of a SSIS package from a Script Task?

I added solution related miscellaneous files into the SSIS package under the Miscellaneous folder, e.g. XML, Excel files. I need to open and read those misc. files in a SSIS Script Task, but I can't find the way either to read or getting the path of…
William X
  • 6,751
  • 6
  • 31
  • 50
2
votes
1 answer

How install Integration Services in sql-2005

I need to install the SQL component Integration Services is to create ETL but the component is disabled, How can I install it?
Luis Primo
  • 25
  • 4
2
votes
1 answer

Executing SSIS package on SQL server 2005

I am working on upgrading legacy applications that used DTS packages. This is the first time working with SSIS packages. The application (which lives in various places) will need to invoke and execute an SSIS package that is on a SQL 2005 server.…
Luther
  • 87
  • 1
  • 9
2
votes
1 answer

SSIS2005: Importing from multiple XL files/sheets with inconsistent metadata

Thanks in advance for any help anyone can provide, (Preface: I'm already familiar with TypeGuessRows registry tweak (I have it set to 0; XL scans the whole column to determine data type) and IMEX=1 extended properties (I use this by default)) I am…
InigoMontoya
  • 49
  • 5
2
votes
1 answer

How to implement the below query using ssis

Can we discuss how to load the below query result into a destination table ,using ssis.I know we can use this in T-sql and also as an OLEDB source query.But still wondering how to implement it ,only using data flow components SELECT CLIENTID …
user1254579
  • 3,901
  • 21
  • 65
  • 104
2
votes
0 answers

SSIS 2005 lookup transformation not capturing non-matching values

I have set up a data flow in SSIS 2005 which checks values from an excel source against a SQL Server query using a lookup and outputs the results to a flat file. This part works fine. However I also want to capture the values from the lookup that…
btecndcomp
  • 21
  • 2
2
votes
1 answer

how to generate client proxy class of a wcf service that will work in the .net 2.0

I have to use a wcf service in the ssis script component which is developing in BIDS 2005. For this i have generated the proxy class of that service using svcutil.exe. After attaching the proxy class in the script component it has error of some…
Amish Kumar
  • 259
  • 1
  • 3
  • 20
1
2 3