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
31 views

Change SSIS package location (REPOST from SO) [closed]

My SSIS Package are located in shared drive with a long path name. To make the packages easier and not to remember long path name, I use "Map my network drive" option and use X: drive as an alias to ...
1
vote
0answers
159 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 ...
0
votes
1answer
24 views

SSIS - Update Specific Cell in CSV

I have a pre-defined csv template. The header row begins on row 5. Prior to this I have a date value in cell B2. How do I update this cell value in SSIS?
2
votes
2answers
98 views

Get rows inserted and updated dynamically in SSIS

I need to get the rows inserted and updated in each table through my SSIS package. Is there any way to do it except using the row count transformation component before each insert or update ...
0
votes
0answers
68 views

Selected Parameter values is not passing to another tab click in SSRS view report

I built an SSRS Report in which the final report is populated on a tabular formatted report with the combination of many sub reports. The report takes 3 input parameters values as date,fund ...
0
votes
3answers
184 views

SSIS or SQL Server way of sectioning a flat file

I have a few hundred thousand flat text files which contain a single column of values. The first 40 values are parameters followed by between 4000 - 8000 rows of sensor data. The files are imported ...
4
votes
2answers
285 views

Loop through tables or copy paste

I have to do a migration where I should retrieve data from 40 Access tables, which should contain several of the same columns (but not all, the schemas are different). To make it simpler, I used SSMA ...
3
votes
1answer
241 views

SSIS Control Flow: Precedence constraints not working as expected

The control flow of my SSIS package is not behaving as expected. What I want to achieve: Test if CLR is enabled on SQL Server using SELECT value FROM sys.configurations WHERE name = 'clr ...
2
votes
1answer
85 views

Proper permissions for ETL user

I'm working on changing the permissions on our ETL to incorporate best practices. This is our ETL in a nutshell: Load 100+ tables from 5 different SQL Servers into stage in DW Call procedures on ...
1
vote
0answers
22 views

Handling changing data in the Fact table

We have an employee & benefits data warehouse which is producing incorrect information in the fact table. In File A (Feb), the employee has a leaving date of 27th Feb 2015. In File B (Mar), the ...
0
votes
0answers
20 views

SSIS - different versions of the project

I am designing the ETL process. I created a package that extracts the data from the source using stored procedures. The SQL query looks like this: EXEC BI.ProcedureName The procedure returns data ...
3
votes
3answers
322 views

Update Table from SP in SSIS

I know there are similar questions to this one, but I could not find one that answered my question. Inside my current SSIS package... I have a dataflow task which... Takes output from a stored ...
3
votes
1answer
2k views

How can I resolve SSIS Excel Connection Manager Error 0xC0209303?

I have created an SSIS package that imports an excel file into a SQL Server table. The SSIS package runs without any problem when I run it locally on my machine but when I run it on the server where ...
1
vote
0answers
33 views

Repeated login issue SQL Server 2008 R2 (SSIS)

I'm trying to figure out an issue I'm currently having with an SQL Server connection - there has been a few issues with timeouts on a SSIS package, where it has failed a login attempt - however as far ...
0
votes
0answers
165 views

SSIS detect & manipulate all user variables ( set all empty )

I am developing a rather large ETL ( 39 distinct Flat File or Excel Connection Managers in current build & about as many to go ) through SSIS ( Visual Studio and MSSQL Server versions both 2008-R2 ...
2
votes
1answer
1k 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 ...
1
vote
0answers
22 views

How do I save my preferences after moving components around in the SSIS Toolbox?

I'm working with SSIS 2012 (SQL Server Data tools), which runs in the VS 2010 Shell. This is my first time working on a project that required us to install some 3rd party SSIS components. ...
0
votes
0answers
29 views

Using TVF as Data Source in SSIS

I have an OLE DB Source Editor. I want to use a Table Valued Function as a data source. I select 'SQL Command' and enter: SELECT * FROM [dbo].[Test] ('UserA','2015/07/31') This works find. However, ...
1
vote
1answer
185 views

SSIS Blocking itself with IsolationLevel read Uncommited and TransactionOption supported

My Project components have IsolationLevel = ReadUncommitted and TransactionOption = supported. My query is a select on table Y verifying if not exists in table X and the result is written to table X. ...
0
votes
0answers
14 views

Downgrading SQL Server 2008 R2 from Enterprise edition to Standard editions [duplicate]

Can anyone tell me when we downgrade from SQL Server 2008 R2 Enterprise to Standard edition in a production environments. What part of SQL Server is needed to install and run a SSIS package? I need ...
4
votes
1answer
231 views

Star join query optimization - Change partitioning, use columnstore?

I am trying to know the best possible way to improve performance of a query given to me by my client. It contains a few tables which are joined and one of table is called dwh.fac_sale_detail which ...
2
votes
1answer
50 views

SSIS: What services to restart so Folder Permissions Propogate to username executing pacakge?

I created an SSIS package that needs access to a folder on a shared drive. The package runs successfully on my local machine but I get an access denied error when I run it on a different server ...
1
vote
0answers
150 views

Using SSIS vs writing your own ETL [closed]

I have two data sources. Data from Questionaires laying in a datatable in the data hosters database (queriable via REST in JSON) Data about clients from salesforce (also queriable via REST in JSON) ...
2
votes
1answer
949 views

Script component source won't load when click “Edit Script…”

I'm working on an SSIS package in Visual Studio 2013. For any script component throughout the package, if I double-click on it and then click the "Edit Script..." button, Visual Studio 2012 opens but ...
0
votes
1answer
3k views

SSIS - Excel destination does not allow characters more than 255

My SSIS package has a ado.net source, which returns columns with width more than 2000 characters,but those columns get truncated when redirected output to excel destination. Any idea, how to resolve ...
2
votes
1answer
676 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 ...
6
votes
1answer
3k views

Assiging stored procedure results to SSIS variable

I am trying to get the value from a stored procedure into an SSIS variable, and then testing to see if two SSIS tasks can work if I added an expression. So for an example, I am trying to use this ...
0
votes
0answers
155 views

SQL Server 2012/SSIS - How to Import Partitioned Table Data to Reporting DB?

What's a recommended SSIS process flow for importing a daily partitioned table to a reporting DB table (SQL Server 2012)? Will be switching partitions on main DB to a staging table each day and ...
0
votes
1answer
55 views

Question regarding flow control of SQL based jobs in SSIS

Question: I have pertaining to SQL and SSIS : How do I make an SSIS package work according to a logical flow that I mapped out for it? Say there are six steps, I have the logic for how they should ...
1
vote
1answer
221 views

SSIS Run Excel Macro Error

I have an SSIS package that populates an Excel file. The package is run from a SQL Server Agent job. It all runs fine, but now I have added a Macro to the Excel file. This macro causes the Package to ...
2
votes
0answers
63 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 ...
2
votes
0answers
155 views

How do I provide a failsafe for retrieval of data from excel to SQL

So say there is a process in place for importing data from excel spreadsheet to SQL using SSIS. And there are two tables, one with new data and one with data from its previous run. I sometimes have ...
5
votes
2answers
277 views

Copy data from multiple databases to a central database for reporting and analysis

I have more than 8 databases and all are in a SQL Server environment. I need to extract data from specific tables (more than 50 tables) of each database and dump into a central database for reporting ...
1
vote
1answer
2k views

SSIS Job “Argument ”ORARA********.xxxxxxx.COM“ for option ”connection“ is not valid. The command line parameters are invalid. The step failed. ” error

My SSIS package is running fine in BIDS but when I tried to schedule the job it's showing: Argument "ORARACOCCUAT1.xxxxxxx.COM" for option "connection" is not valid. The command line parameters ...
1
vote
1answer
62 views

dtsinstall.exe does not deploy packages

I created SSIS project solution in VS2008. I created 5 packages and deployed them to SSIS Storage succesfully. I executed 4 packages successfully. I leave SQL server few days alone (holiday!). I ...
1
vote
1answer
469 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 ...
1
vote
1answer
2k views

SSIS - insert system date variable as a execute sql task parameter

I am trying to insert the system:starttime variable into a table by passing a parameter into an execute sql task. I dont have much knowledge of SSIS data types, and I am currently having trouble ...
2
votes
2answers
127 views

SSIS compatibility

I'm trying to use SSIS for preparing data warehouse and for making business objects for report generator. The problem is that i have to support multiple sql server versions - sql server 2008r2 and ...
2
votes
0answers
57 views

incremental update in HBase using sqoop

i am working on a POC where i need to implement same like SSIS for sql to hadoop. out DW are in SQL Server and we want to create a HBase at central location where all the data from diff DW will be ...
4
votes
2answers
445 views

SSIS Package Error when called from SQL Agent Job

We have SSIS running on its own server under account 'ourserviceaccount'. We then have SQL Agent running on a separate server under the same account. I have set up a job that calls an SSIS package, ...
1
vote
0answers
185 views

Is there any way to set the default data source for the SQL Server Import and Export Wizard?

When I launch the SQL Server Import and Export Wizard for SQL Server 2014, the selection in the Data source drop-down defaults to .Net Framework Data Provider for ODBC. This happens regardless of ...
2
votes
1answer
37 views

Demographics Dimension Table - Finding the Key!

I have a dimension table which captures demographics on Employees. The schema is similar to below: CREATE TABLE [dbo].[DimDemographics] ( [DemographicsKey] [int] NOT NULL, [AgeBand] ...
-1
votes
2answers
2k views

How to Execute multiple select statements in SSIS 2008 using Data flow task [closed]

I am migrating data from one database to another database using SSIS package and i need to write multiple select statements for same table depending on conditions as mentioned below. Actual Queries i ...
0
votes
0answers
16 views

Update source table from SSIS after Inserting in Destination [duplicate]

I am using SSIS 2012 from visual studio to extract all email information from source tables as follows: Data flow to take data from Notifications table in App1 Store that in SQL Destination. ...
8
votes
4answers
3k views

Is it possible to develop a SSIS with a SQL Server Evaluation Version

We are thinking about buying an SQL Standard Server for implementing an ETL via SSIS. Since it is very expensive for us I would like to test developing SSIS Packages on a free version. Since the ...
10
votes
1answer
1k views

Avoiding “Row by row” fetch method when dealing with source LOB columns

I have a legacy PostgreSQL database source (ODBC) that I'm attempting to migrate to new SQL Server schema using SSIS. I'm getting a warning saying: 'Row by Row' fetch method is enforced because ...
3
votes
1answer
192 views

SSIS Repeated Header In CSV File

I am writing to a csv file in a Foreach loop. For each loop the code is writing the header so it appears repeatedly throughout the file. How do I ensure the header only appears once? I have tried ...
2
votes
3answers
6k views

How to import table's data in MySql from Sql Server?

I am trying to export table from SQL Server 2008 R2 TO MySql 5.5. For this I am using SQL Server Import and Export Wizard of Sql Server 2008, but it is giving this error. Here this error may be ...
2
votes
2answers
518 views

Why would a job call a batch file with dtexec.exe instead of just calling the SSIS package directly?

I've inherited a SQL 2012 server with a number of jobs that call SSIS packages. Instead of the more obvious solution (calling them directly from a "SSIS Package" job step), these jobs use a CmdExec ...
2
votes
1answer
245 views

SSIS Update (Replace) record instead of append based on Primary Key

I created an SSIS Pacakge that imports a monthly extract claims file. I have a simple Data Flow task, flat file to OLEDB Destination with a Derived column component in between used to generate a ...