SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.

learn more… | top users | synonyms

4
votes
0answers
142 views

Can't use Fuzzy Lookup in BIDS

A coworker of mine was having an issue with BIDS. He's doing a simple fuzzy lookup and is only looking against two rows(For Testing Purposes). The weird thing is that when he tries to execute an ...
3
votes
0answers
557 views

SSIS Recordset Destination error

I have an SSIS package targeted at SQL Server 2012. I have it deployed into the Stored Packages in Integration Services and then have a SQL Server Agent job which executes it. The first part of the ...
2
votes
0answers
174 views

SSIS Bulk Insert Task Operating system error code 1311

I have been running SSIS 2008 R2 Packages for a long time and when ever my Packages trough SQL Server Job accesses FTP Server which is on the same domain it uses correct credentials ,e.g. ...
2
votes
0answers
209 views

Limit Output Flat File Size In SSIS

I am using Flat File Destination to export my data's to a Text file. I need to limit the output File size to 1 MB. Is it possible?
2
votes
0answers
547 views

Importing Excel files with SSIS

I'm trying to import an Excel spreadsheet into SQL Server 2012 using SSIS. There is only one sheet in the file. The file is a SalesForce export. I believe the Sheet name changes depending on when the ...
2
votes
0answers
117 views

How to use a foreach loop with project deployment model

I have a SSIS project that is configured to project deployment model, within this I have two connections one for a flat file and one for a sql db. Both connections are in project mode. Now I want to ...
2
votes
0answers
353 views

Microsoft Visual Studio is Busy

I am working in Visual Studio 2008 on a SSIS package. It is really frustrating that I get "Microsoft Visual Studio is Busy" message quite often. It almost happens every time I try to open a data ...
2
votes
0answers
1k views

Create SSIS package to copy data between SQL Server 2008 installs on different machines?

I'm new to the whole SSIS world. I'm trying to create a process to copy data between SQL Server 2008 environments. I want to be able to run a job to export data from my prod database and then use that ...
2
votes
0answers
489 views

SSIS - Derive column values based on join/subselect from a non-table source

I have a flat file source that contains a lot of duplicate records, which have the same key fields but differ by their "changed date". I need to split this up into two outputs, one for the "latest" ...
1
vote
0answers
68 views

How to use HTTP Connection Manager in Script Component? (Not Script Task)

I'm trying to perform the same scenario as in the following link; Create a SSIS Script Component as a Data Source that uses a pre-existing HTTP Connection Manager to retreive a page with GET and emit ...
1
vote
0answers
68 views

Oracle 11g SSIS SQL Server 2014 Truncation

We have a nightly SSIS job which downloads data from a Vendor's ORACLE system into our SQL Server 2014 system using ORACLE's Wallet. On some tables, we've noticed that some VarChar columns have last ...
1
vote
0answers
37 views

expression to transform 'I' to 0

I have data ActiveNonActive columns in and the data are A,I,Empty I have Derived Column to transform data to bit i or empty--->0 and A->1 just want to ask how to use expression transform the 'I' ...
1
vote
0answers
16 views

update new ID_MergeTo from operation table ID if MergeFlag is true and MergeTo defined?

I have problem I don't know how to solve it. I have two tables Staging and Operation.I create Data Flow Task using SSIS to move data columns from ...
1
vote
0answers
35 views

Run SSIS task regardless of checkpoint

Is it possible to make a task always run, regardless of whether the package starts from scratch or from a checkpoint restart?
1
vote
0answers
60 views

Cross Server and Instance Login SSIS SID or ID Issues

I have some challenging login/SID/ID issues with authentication between databases on separate instances and servers. We have a Development, Test, Pre-Production and Production server/instance ...
1
vote
0answers
51 views

Will redeploying a project to the SSISDB invalidate current jobs

I’ve been given 2 dtsx packages to replace 2 in production. This is for a SQL 2012 server with the packages deployed in the project model. The only way I see to do the update is to export the project, ...
1
vote
0answers
99 views

Errors in the metadata manager. The process type specified for the Effect dimension is not valid since it is not processed

Trying to hunt down an issue with an SSIS package we have and I don't know what to look for to help correct this issue. Error: Errors in the metadata manager. The process type specified for the ...
1
vote
0answers
96 views

How to copy a subset of SQL objects across databases within a transaction?

We already have a .dtsx package to copy a subset of tables (about 20) from one database to another (at least once in every month). It is using "Transfer SQL Server Objects Task". However this does not ...
1
vote
0answers
96 views

What type of fact table / loading solution for a reservation system?

I am designing a Data Warehouse with SQL Server 2012 and SSIS. The source system handles hotel reservations. The reservations are split between two tables, header and header line item. The ...
1
vote
0answers
260 views

Timeout while using table valued parameter

I'm trying to find the cause for this error while calling a stored proc with a table valued parameter: Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target ...
1
vote
0answers
535 views

In the Import/Export Wizard inside SSDT, why is the MSAccess DB Engine data source looking for a workgroup information file?

Running MSSQL12, VS10 Shell, MSA2013 with local .accdb files, Microsoft Access Database Engine 2010 Redistributable (x86_64) and Microsoft Access Database Engine 2007 Redistributable (x86) installed. ...
1
vote
0answers
301 views

CDC with SSIS: process all changes in order of occurrence

I have a SSIS package that I'm using to sync (in an on going basis) all changes from one table to another. Note that I need to sync ALL changes and not just NET changes. My problem is that I cannot ...
1
vote
0answers
2k views

MS SQL Server - Login timeout expired

I am doing this tutorial of Microsoft: Basic Data Mining Tutorial http://technet.microsoft.com/en-us/library/ms167167.aspx I am using SQL Server 2012 and SSIS - SQL Server Integration Services but I ...
1
vote
0answers
55 views

Integration Service cannot be upgraded/removed

I have Sql Server 2005 Integration Services installed in our server whose version is 5292. It needs to be upgraded to version 5324. After running the patch the summary report says it is upgraded ...
1
vote
0answers
200 views

What is the best process for merging packages to use SSIS package configurations?

I have several packages with hard coded connection managers which I would like to merge into one package. Each individual package is currently loading a single data file to a single table is a single ...
1
vote
0answers
83 views

Displaying SSIS variabe values in Integration Services Dashboard

I have an SSIS package that executes stored procedures which return output parameters into ssis variables. How can I easily display these variables content in the Integration Services Dashboard ? ...
1
vote
0answers
36 views

SSIS 2008 Connection Managers (Project Specific) and Corresponding Configurations

These are the requirements that I want to complete: a. I want the package to only use connection managers that are project/not package bound. b. I also want these connections to be bound to the ssis ...
1
vote
0answers
304 views

Can SQL Server 2008R2 SSIS packages access SQL Server 2012 databases with driver updates only?

We have two products running on SQL Server that we will be upgrading to SQL Server 2012 on a staggered schedule. Product B uses SSIS packages (using ODBC drivers) to extract data from Product A's ...
1
vote
0answers
268 views

Accessing environment variables at design time in SSDT?

I'm re-designing some SSIS packages for 2012 and some parameter/variable/configuration issues are not clear to me. The result that I am trying to achieve is that the user context's temp folder(stored ...
1
vote
0answers
2k views

SSIS Merge Join Trouble: 3 tables into 1

So I am having trouble merging three tables into one. All sources are DB, and I am using the MERGE JOIN function. When I join my first two tables, using standard left inner join, it returns the exact ...
1
vote
0answers
258 views

Login failed for user sa ssis 2008

I have a problem with ssis2008 I built a package that have a connection with SQL Server authentication (username : sa). When I use BI, it works fine but when I build a job that used this package it ...
1
vote
0answers
139 views

Requesting advice on creating a table controlled SQL job scheduler

I have been tasked with cleaning up a series of SQL jobs that send email updates about various data and system conditions in my company. Currently, there are a ton of jobs, each with its own SQL code ...
1
vote
0answers
116 views

Where can I get information about AcquireConnection call?

I have a dtsx package that fails to run. When I turn on logging I get: The AcquireConnection method call to the connection manager "MY_DSN" failed with error code 0xC0202009. MY_DSN is a ...
0
votes
0answers
13 views

SSIS Transaction Set to Required giving error

I want to use transactions in SSIS insert update. My package is working fine but When i set transaction option to "Required" i am getting an error like [OLE DB Source [23]] Error: SSIS Error Code ...
0
votes
0answers
38 views

Error while executing SSIS package which contains Script component through SQL Server Agent Job

I have written one SSIS 2012 package which is fetching records from CSV and put it into staging DB and from staging DB , using SSIS script component task, I am inserting data into Dynamics CRM. So far ...
0
votes
0answers
53 views

Split and Concatenate data

I have a group of fixed width text files that come in daily. These files contain thousands of records each.Each record has an (01) as Header (02) as Detail 1 (03) as Detail 2 I would like to ...
0
votes
0answers
47 views

SSIS - ODBC Parameter Size

I have created a SSIS package which runs every hour from my Machine. First part of my Package runs a Execute SQL Task and result set (single row, single column) is a comma separated list of Unique ...
0
votes
0answers
60 views

SSIS cannot access the file

I have a SSIS package which performs a few tasks using SQL Server Agent. First it executes a script task, then accesses Excel files, executes a SQL query and moves files to another directory. The ...
0
votes
0answers
190 views

Connecting SSIS to Oracle using Attunity Drivers

I am trying to recreate the steps I took to allow me to connect to 64bit Oracle installation from SSIS using the Microsoft Connectors 3.0 for Oracle and Teradata (Attunity driver). MY issue is I ...
0
votes
0answers
41 views

How to specify localhost for SSIS package source server?

I have a job running on SQL Server 2012, where one of the steps is of type "SQL Server Integration Services Package". For the "Package source" I choose SSIS Catalog. For the "Server", if I type in the ...
0
votes
0answers
264 views

SSIS package error, can't find pre-compiled script

I'm working with an SSIS package (Visual Studio and BIDS/SQL Server 2005 SP3) and out of the blue my script tasks have started failing to compile. The actual error message: Validation error. ...
0
votes
0answers
101 views

I want to ignore all SSIS errors, and copy over every row with the error column simply set to NULL

I have a simple SSIS package that reads from an OLE DB Source (Oracle), goes through a conversion transformation, and then to an OLE DB Destination (SQL Server 2012). I have configured the error ...
0
votes
0answers
102 views

SSIS Project Deployment - Is it better to deploy many projects or many environments

I am looking to migrate our old ssis packages (from an earlier version) which have been deployed using the package deployment model, to use the new project deployment model. This bit I can easily do. ...
0
votes
0answers
318 views

How to run 2008R2 SSIS packages on SQL Server 2014 Standard environment?

I have a .NET application which is executing SQL Server 2008 R2 SSIS packages and the application is running on Windows Server 2008 R2 (64bit). These packages were built in BIDS 2008. After that, I ...
0
votes
0answers
53 views

How can I use parameters of type Int32 from an environment for an integration services package in a SQL Server 2008 job?

I made a SSIS package using two string parameters and one Int32 parameter. I defined a SQL Server Agent job that should execute that package. In "Integration Services Catalogs" I definied an ...
0
votes
0answers
193 views

SSIS - Multiple data source and single excel destination, causing SqlDumper error

Brief Architecture: I am creating a SSIS package to generate Excel reports with single excel, but multiple sheets. User can select single or multiple reports for export. There are different types of ...
0
votes
0answers
32 views

Got error with lookup transformation in sql server 2005 BIDS

I have query to seperate the current and history DB's ** select , year(doj) from source where year(doj)<=(year(getdate())-3)* Here the moved data(<=2011) from current DB should be deleted and ...
0
votes
0answers
85 views

SSIS - the 1st item in the data flow package view always imports way slower than the others

In the SSIS data flow task, I've been importing CSV files to my SQL Server via Flat File Source -> OLE DB Destination. When I'm setting things up in the package design preview, if I have just one ...
0
votes
0answers
535 views

How can I resolve timeout errors in SSIS around midnight every night?

I find a pair of these in my Application Event Log a little after midnight every night: The SSIS Execution Process could not write to the IS catalog: MyServerName:SSISDB Error details: Unable to ...
0
votes
0answers
112 views

How to fix type conversion error in Data Flow task?

I have an SSIS job with a data flow task having an OLEDB source and OLEDB destination. I am moving almost 40,000 rows from one DB to another DB. In my SQL query**(Source**) , i have 10 columns all ...