SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.
0
votes
1answer
140 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
27 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
148 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
205 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
110 views
SSIS SQL Server 2012 cluster Availibility Group
We have a three server cluster using AlwaysOn technology, and have created an Availability Group for the SSISDB catalog.
How would you change the code to only execute on the primary server?
0
votes
1answer
69 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
153 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
0answers
17 views
Connecting to Oracle from SSIS using ODBC
I am using SSIS to pull data from Oracle DataSource. In the Connection when I chose the Oracle provider and gave the necessary inputs I got error saying "Oracle client and networking components were ...
0
votes
0answers
35 views
XML data source with XSD validation importing the same data despite different files
Please bear with me, I've never used XML as a data source, nor am I familiar with XML itself, so I'm not entirely familiar with the nomenclature.
I have a series of XML files with data to be imported ...
0
votes
0answers
52 views
Transfer tables from multiple servers into one single server [duplicate]
I have to migrate similar tables present in multiple different servers (30+) into our new server using SSIS package. What would be the right approach towards this?
I was successfully able to transfer ...
0
votes
1answer
521 views
How to override SSIS 2008 package config file path?
I have an SSIS 2008 package with a single configuration named Config. I would like to use the dtexec /SET switch to change the path of the config file that it uses so our developers that build the ...
0
votes
0answers
59 views
SSIS Data Flow Task Slows Down
I am trying to transfer data from one table to another in the same database using SSIS. It seems to go fine (I can see the record count going up) until it gets to about 30 million records, then it ...
0
votes
0answers
40 views
How to Copy Yes/No field data in Sharepoint list to Sharepoint list using SSIS Package?
I am copying sharepoint list data using SSIS package and they are copying perfectly. But the problem is when there is a Choice field or Yes/No field at that time it is copying only default value to ...
0
votes
0answers
55 views
Errors loading one set of data from Staging to Data Mart Fact Table
I am very new to SSSIS and am trying to load sales data from 3 sources. I have created data flows to extract the source data into staging, all of these work OK with no error. I now want to load ...
0
votes
0answers
20 views
Twice job results in sql server, last one is left in progress [duplicate]
I have the job MP - Create CSV which execute a package SSIS in sql server 2008, when I check for the job history I see the result at step 0, I expand and I have 2 results for the step 1.
Fist result ...
0
votes
0answers
360 views
Using SSIS to download an attachment from Exchange/Outlook
I am recieving a weekly email that includes an attachment of an excel file. I'd rather not how to manually drop this email in a file location or manually update the data. I'd like to use SSIS to ...
0
votes
0answers
81 views
SSIS delete records that were deleted
I'm new to SSIS. I'm trying to create a Package that will transfer data from one DB to another one. I created the UPSERT task for each table using using Slowly Changing Dimension. It works pretty ...
0
votes
0answers
209 views
SSIS package to create maintenance plan fails silently
Here's what I did:
Connect to SSIS on server A (from management studio on server B, click connect, choose integration services, choose server A)
Find required maintenance plan
Right click and export ...
0
votes
1answer
584 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 ...
-1
votes
1answer
142 views
SSIS SQL Result to tab delimited txt file [closed]
I have created a package that Runs a Sql Query and then puts the results into a flat tab delimited txt file.
When I opened the flat file in excel everything was in the right columns but in columns ...
