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

0
votes
1answer
51 views

how to downgrade a statement for SSIS

Following snippet works within SSIS 2012 --- derive colum block. TOKEN(REPLACE(@[User::FileName],".csv",""),"\\",TOKENCOUNT(REPLACE(@[User::FileName],".csv",""),"\\")) But it does not work within ...
0
votes
1answer
172 views

Does failed task considered to be run to completion in SQL Server maintenance plan terminology?

The replies to my previous question: "How to specify a SQL Server maintenance plan subtask to run unconditionally on success or failure of preceding tasks?" answered me that I should change ...
0
votes
2answers
697 views

Copy data through SSIS package from one machine to another

I have data in few excel sheets which are to be loaded into tables. I've created a few SSIS packages to do this on my local machine. Now I have to move these tables onto my client's machine, which is ...
0
votes
1answer
492 views

SSIS Raw Data Import Into SQL Server 2008 R2 - Truncation and Condensed Data Type

[Intro] I have written a two pack SSIS solution to perform a scheduled hourly update of data from multiple tables in a single db (SRC) to single table on another db (TRG). I get the following errors ...
0
votes
1answer
37 views

Concurreny update error when using SSIS

I am encountering concurrent update error when using OLE DB command to execute a update procedure in SSIS. Below is the segment of code which will check for concurrency update. Currently I removed ...
0
votes
1answer
878 views

Convert rows to columns in SSIS. Unpivot?

If I have data like this "","",WAREHOUSE ID,1,2,3,4,5... "","",WAREHOUSE CODE,BOS,HOU,LAX,NYC,CHI... "","",WAREHOUSE NAME,BOSTON,HOUSTON,LOS ANGELES,NEW YORK CITY,CHICAGO... But want to transform ...
0
votes
2answers
516 views

Import batches of rows from Excel in parallel

We receive an Excel file weekly currently containing about 250k rows. The file grows by about 300 rows each week. In SSIS I've hooked up an Excel source to an OLE DB destination to import the file ...
0
votes
1answer
98 views

Logging of incorrect row in SQL Server Integration Services

I newbie to SQL Server Integration Services and I have a problem: Data loaded from file looks like this: 1 'a' 'b' 2 'a' 'b' 1 'c' 'd' And this rows would be loaded in table like this: CREATE ...
0
votes
1answer
672 views

Performance comparison in ways a SSIS package can be run

I'm wondering if there is any difference in performance of a SSIS package if it runs using SQL Server job, vs running using DTEXECUI.EXE Utility or running in BIDS? Also if the target database in on ...
0
votes
1answer
1k views

SSIS transfer SQL server objects task -> Foreign key constraint error

I try to copy a database from 1 server to the other to build a staging environment. I do this with SSID. First I delete the existing database on my staging server, create a new and empty one and then ...
0
votes
0answers
35 views

Decimal Data Type as Primary Key

One of my tables is set up like this: create table dbo.Source ( testID decimal (10,3) PRIMARY KEY , column 2 somedatatype , column 3 somedatatype ) Whenever I perform SSIS into this table ...
0
votes
1answer
20 views

SSIS Package not retaining parameters in SQL Server agent job

I have an SSIS package stored in the Integration Services catalogs on a SQL server instance. This package is used as a step in a SQL Server agent job. The package has 4 required parameters. Using ...
0
votes
0answers
18 views

Problem running SQL Server 2014 SSAS in an SSIS package

I have a SQL Server 2014 AlwaysOn environment setup with 3 nodes. It is a QA environment. I have a user who is trying to run an SSIS package against an SSAS cube. He can manually run the process in ...
0
votes
0answers
9 views

SSIS Export to flat file with fixed column widths - add record with a different format?

I am exporting a table to a flat file with a fixed-width format in SSIS. At the bottom of the file, I need to add a "trailer record" for balancing that will total up a few values. This record needs to ...
0
votes
0answers
29 views

Security for SSIS packages in SQL Server - use a domain account?

I have an SSIS package that I want to deploy to SQL Server A. This package needs to access tables on SQL Server A, and another SQL Server, B. What is the best way to set this up? Should I create a ...
0
votes
0answers
25 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
177 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
2answers
55 views

SSIS import data or insert data if no match

I have a situation in which I need to import data from one table to another. The challenge here is in tables I have some columns which are references to other table values (kind of foreign key). I ...
0
votes
1answer
123 views

Error while running SSIS Package job in SSMS

Error while running SSIS Package job in SSMS Hi! A SSIS package named "My_Package" has been scheduled as a job in SSMS to be executed daily at 5:00 AM daily. SQL Server Version : Microsoft SQL ...
0
votes
1answer
91 views

Error message when importing data into SQL (Import & Export Data Wizard)

I am trying to use the Import & Export Data Wizard to import the contents of a CSV file into a table in MSSQL. I have no issues if I import all columns as strings however, I need one column to be ...
0
votes
1answer
47 views

SSIS append trailer with Script

I am trying to add a footer to a flat file output. I have 2 data flows in my control flow. One creates the file from the DB. It goes from OLE DB Source to Flat File Destination. The second control ...
0
votes
0answers
56 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
1answer
148 views

SSIS Dataflow Task issue, moving data from SQL Server 2008 to MySQL via ADO.Net

Can you please help me in getting this problem solved.. I'm trying to build a SSIS package where I'm moving the data from SQL Server 2008 to MySQL. However I'm getting a weird problem in dataflow ...
0
votes
1answer
215 views

SSIS import with header record

I have fixed length text files that I have to import into SQL Server daily. These files contain header records (01) and Detail records (02). I am trying to build an SSIS package to do this. I have a ...
0
votes
1answer
37 views

SSIS Condition that include two connections/data bases

In a SSIS package , I need some sort of condition that include two connections. The simplified problem is: A simple CSV import to SQL Server, DB1, table 1( col1, col2 ). I need to populate table 1 > ...
0
votes
1answer
86 views

Loading XML data from SQL Server directly into MarkLogic?

Has anyone loaded XML data from SQL Server to a MarkLogic document store? This would be preferable to dumping XML to file system and then using mlcp. Maybe with SSIS?
0
votes
0answers
88 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
292 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
1answer
47 views

Unable to call sp_start_job from website only

I have an agent job that I'm trying to use to kick off an SSIS package via a web page. I have configured my web site running in an application pool as user X. When I invoke sp_start_job as use X ...
0
votes
0answers
47 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
352 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
141 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
1answer
172 views

SSIS 2012 metadata not refreshing on re-deploy

I have three systems: DEV, UAT, PROD, all running SQL 2012 Enterprise. I have existing packages that hit objects on these systems. Every time I have to make a change that affects metadata, it's not ...
0
votes
0answers
132 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
17 views

SSIS Performance tunning [duplicate]

I have few questions on SSIS Performance tunning. Suppose My system has 8GB RAM and I have installed SQL Server 2012 along with DataTools. SQL Server uses 7GB memory. Will SSIS uses the 7GB memory or ...
0
votes
0answers
14 views

not able to create SSISDB catlog in Sql server 2014 [duplicate]

getting below error while trying to create catlog in slq server 2014 integration services. any idea what i missed in installation or anywhere else? The catalog backup file 'C:\Program Files\Microsoft ...
0
votes
1answer
134 views

Apply settings to multiple output columns in SSIS flat file source

Is there an easier way to apply property settings to multiple output columns in a SSIS flat file source, rather than manually applying to each output column? (SQL Server 2014.) I am attempting to ...
0
votes
1answer
40 views

SSIS permissions for specific databases

I'm quite new to SSIS. Is it a straightforward to grant SSIS permissions in the AD environment so that that a user can only create/manage/run ETL tasks on specific databases/Analysis Services ...
0
votes
0answers
364 views

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

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
1answer
39 views

Modeling global and private parameters

I'm trying to model a database that will be used for management and execution of SSIS packages. The entities are Client, Job and Package. A Job is the managed unit that references Client and Package. ...
0
votes
0answers
58 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
1answer
86 views

SSIS unpivot returns different results when run via a SQL agent job

I hope someone can help me. I have an SSIS package which grabs data from an excel (.xls) file, unpivots it from a rubbish format into a 'proper' format, transfers it to a SQL server 2008 R2 db, and ...
0
votes
1answer
724 views

How to deploy SSIS package with XML config, using SQL agent

I wonder if anyone can help me with a question. Context I've created a database which needs a front end in MS Excel. When the user presses upload button I want it to start an SSIS package which moves ...
0
votes
0answers
207 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
1answer
130 views

How can I restore ##MS_SSISServerCleanupJobLogin##?

At some point the SSIS cleanup job login (##MS_SSISServerCleanupJobLogin##) got deleted from my sql server (2012). I'm trying to upgrade to SP2 and I'm getting an error message I believe is related to ...
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
1answer
470 views

execute [SSISDB].[catalog].[create_execution] with 'execute as"

We are testing a 3rd party tool to schedule/execute jobs in our environment so trying to test launching SSIS packages within the integration service catalog. I have found examples of the code to run ...
0
votes
1answer
1k views

SSIS Package Validation Error when Executed From Windows Task Scheduler

I have deployed my SSIS package using the project deployment model to the SSIS catalog and experience a strange validation error when I try to execute the package. I believe this is due to a ...
0
votes
1answer
817 views

Invalid date format in SSIS

I am using BIDS to export data from Oracle to SQL server. I am using OLEDB source and destination. I have around 6 datetime fields in ORACLE out of which two fields give no problem while 4 fields give ...
0
votes
0answers
89 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 ...