SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.
2
votes
2answers
226 views
Error trying to run SSIS Packages in SQL Server 2008 SQL Server Agent
I am trying to run a number of SQL Server 2008 stored procedures that are wrapped in SSIS packages consisting mainly of Execute SQL Tasks. They run fine in Visual Studio 2008 after deploying to a ...
1
vote
2answers
442 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 ...
0
votes
2answers
50 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 ...
2
votes
1answer
185 views
SSIS Package Data Flow Task RollBack on Error
I tried running a package and it failed but I noticed in the output box (in visual studio) that it managed to write 2000+ rows to a table. I was wondering if an SSIS package would roll back the ...
2
votes
1answer
79 views
Twice job results in sql server, last one is left in progress
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 ...
2
votes
1answer
293 views
Is there a way to do data export from Amazon Web Services RDS for SQL Server to On-Premises SQL Server?
We have a large Amazon Web Services RDS for SQL Server instance and we would like to do incremental data transfers from RDS to On-Premesis SQL Server on a regular basis.
The On-prem server will be ...
1
vote
1answer
42 views
SQL Server 2012 catalog.executions to sysjobhistory - any way to join them?
I have exhausted my resources and can't find a foolproof way to join the ssisdb.catalog tables to the jobs that run them. Trying to write some custom sprocs to monitor my execution times and rows ...
0
votes
1answer
170 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
1answer
176 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 ...
3
votes
0answers
140 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 ...
3
votes
0answers
420 views
SSIS Script to split string into columns
I have a dataset (log file) with a number of columns; one of them is "Other-Data" below (unordered string) and need to parse the string to create the derived columns according the u value (U1, U2, U3, ...
3
votes
0answers
568 views
SSIS Row Count: Getting a null variable error where there is clearly a selected variable
Validation error. Build Files Count VIE [245]: The variable "(null)" specified by VariableName property is not a valid variable. Need a valid variable name to write to.
From what I can tell, this ...
2
votes
0answers
41 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
311 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
75 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
119 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
575 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
180 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
107 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
60 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
196 views
sql agent job hangs without any errors or warnings
Problem:
we have a SQL Agent job which runs everyday in the morning at 4:00 am. This job hangs sometimes without providing any errors or warnings. It just hangs. BUT when i stop the job and run again ...
1
vote
0answers
81 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
208 views
Login failure when running a SSIS package from a SQL Server job
I have a SSIS package that migrates data from a Sybase database to SQL Server. The connection to the source database has been made through an ODBC connection.
If I run the package directly on my ...
1
vote
0answers
88 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 ...
1
vote
0answers
1k views
Error Authenticating Proxy Account when Executing SSIS job
I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages.
These packages have been running for years and the associated steps run via a Proxy Account ...
1
vote
0answers
126 views
Is there a way to use a SQL Server 2000 database in SSIS 2012?
I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and ...
0
votes
0answers
49 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
35 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
45 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
309 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
79 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
196 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 ...
