Stack Overflow
Stack Overflow

Questions tagged [ssis-2008]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2008 is a part of SQL Server 2008 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

448 questions
13
votes
1 answer

Error : The result binding name must be set to zero for full result set and XML results

I have only a single row that is being returned from a sql query(count(*)), but upon execution of the package, it shows me the above error and package is failing. I have the result type to "single row", and have mapped the output of the…
WhoamI
  • 336
  • 1
  • 3
  • 12
9
votes
2 answers

How to pass parent variable value to child package for reference type: External Reference

I have a ssis project in which the master package contains many child packages. All the child package are invoked with execute package task. I need to pass the "begin date" value from master to all the child package. I know we have parameter binding…
Remi
  • 214
  • 5
  • 17
8
votes
5 answers

SSIS Error code: 0x80040E37

There is a dataflow task,which consists of excel source and sql destination.When executing dataflow task alone it is runing good.If i execute this dataflow taks inside a a for each loop ,it gives below error [Excel Source [17]] Error: SSIS Error…
user1254579
  • 3,901
  • 21
  • 65
  • 104
7
votes
2 answers

How to get unmatched data between two sources in SSIS Data Flow?

I have two data sources, one sql table, one flat file (csv). Both sources have exact same columns. Example Data: Table: HCN Name Surname DOB 111 John Black 2013-12-10 222 Jack White 1989-01-14 333 Brian Brown …
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
7
votes
3 answers

Skip rows: Export data from SSIS into excel file

I am trying to export data from a SQL server database into an excel file using SSIS. I want the data to get inserted from the 6th row and 5th row has headers. I am able map the header names, in Excel Destination Editor, to the SQL table headers, by…
SMS
  • 73
  • 1
  • 6
6
votes
4 answers

Convert string variable to GUID

I want to use an Execute SQL Task query to return varbinary data from a database table. The query requires a UniqueIdentifier as a parameter which is stored as string in a Package variable. The result of this query (the varbinary data) will be…
Master Yoda
  • 4,334
  • 10
  • 43
  • 77
6
votes
0 answers

Export Wizard SQL Server Management Studio cannot locate mapping file cannot convert data types to fit Postgresql

I want to export databases from our SQL Server 2008 to our PostgreSQL server. The problem is that during the Import/Export Wizard the Wizard says that he cannot find the correct file to convert properly. (If I proceed he exports without checking…
Puddingloeffel
  • 163
  • 2
  • 9
6
votes
3 answers

How to log the output of SSIS Execute SQL Task

I am new to SSIS. I created SSIS Package using Execute SQL Task. I called a Stored Procedure. My stored procedure prints few messages like 'Insert Started' 'Update Started' 'Update Completed' but it does not return any result set. How do I write…
StackUser
  • 5,370
  • 2
  • 24
  • 44
5
votes
3 answers

Execute Stored Procedure with multiple result sets

I am using SSIS 2016. I need to execute a stored procedure that returns 4 result sets. I only need to keep the first result set and write this to a table. I can not modify the stored procedure. I do not care about any of the data returned in the…
Chris
  • 53
  • 1
  • 4
5
votes
2 answers

what is the use of Miscellaneous Folder in SSIS Solution

What exactly is the use of Miscellaneous folder in the SSIS Solution folder hierarchy? I have use many packages and solutions as a part of the project,but never used this folder.I do understand that ,one can import various files over here. Can any…
user1254579
  • 3,901
  • 21
  • 65
  • 104
4
votes
1 answer

How to update activeX Script task

We are migrating some packages from sql server 2008 to 2016. But the ActiveX script task isn't loading correctly. I am very new with this tools. I would like to know how to update this kind of task. Thanks in advance
Hugo Gonzalez
  • 189
  • 1
  • 11
4
votes
2 answers

SSIS Variable in Data Flow Task used incorrectly

In the SSIS Package I have several Data flow Tasks where I want to use one input global variable named KOERSEL to go back in time and call data set specifically in time. When I try to run it I am getting the error: Syntax error, permission…
Ilovetofake
  • 59
  • 3
4
votes
1 answer

How do I use DTS.Events.FireInformation() in SSIS Script Task while handling WinSCPnet.dll FileTransferProgress?

I have a Script Task in an SSIS (2008) package that downloads files from a remote FTP server to a local directory. The Script Task is written in C# 2008, and uses WinSCPnet.dll. Using examples from WinSCP's documentation, I came up with the script…
digital.aaron
  • 5,435
  • 2
  • 24
  • 43
4
votes
2 answers

SSIS 2008 R2 - "Excel Connection Manager" failed with error code 0xC0202009

We are facing below error after Microsoft's October patches applied on the server. We have set Run64BitRunTime to false and DelayValidation to True and changed path of the excel folder. Still facing below issue. Error: 0xC0202009 at…
Tech Learner
  • 1,227
  • 6
  • 24
  • 59
4
votes
3 answers

SSIS read flat file connection on script task

I'm working on a 2008 SSIS in which I need to read a flat file so that I can access its content (which has 3 directories paths), so I can store those 3 paths into variables. The flat file would be in 3 different servers, according to the instance…
Rambo3
  • 381
  • 1
  • 4
  • 18
1
2 3
…
29 30