SQL Server Integration Services, used for data migration in and out of Microsoft SQL Server

learn more… | top users | synonyms

4
votes
1answer
706 views

Distributed and/or Parallel SSIS processing

Background: Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
1
vote
1answer
23 views

SQL Server Agent Service - SSIS package scheduling not working

We have a local admin privilege to our VPN users and we have created SSIS packages but not able to run it through SQL server agent services as its not allowing to run throwing error being non-...
1
vote
1answer
799 views

Deploying an SSIS Package - TNS:could not resolve the connect identifier specified

I have an SSIS package which has 4 connections - a WebService, 2 SQL Server connections (across 2 domains), and 1 connection to an Oracle DB. When the package is run from Visual Studio from a laptop, ...
1
vote
1answer
352 views

PostgreSQL - Using COALESCE keyword in SSIS

When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set. I am using a Native OLE DB\PostgreSQL Native Provider as a ...
1
vote
1answer
440 views

How do I filter duplicates from a sharepoint list using ssis

I have successfully connected a sql data base to a sharepoint list using ssis. The problem is that every time I run the project all the data gets dumped into the list and causes duplicates. Is there ...
0
votes
1answer
31 views

SSIS 2014 - map NFS

We are migrating SSIS from SQL 2008 to SQL2014. Old OS: WINDOWS 2008 R2 SP1 New OS: WINDOWS 2012 R2 I use the Execute Process Task to map an NFS share to a drive. Executable: C:\Windows\System32\...
0
votes
1answer
656 views

SSIS package hangs on Setting Source Connection

I have an SSIS package that has been executing successfully for the last 7 years. All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via ...
0
votes
1answer
991 views

Error with SharpZipLib in Script Task SSIS 2008

I am trying to create a script which can Zip any file on the fly. For this a DLL SharpZipLib i have used. But unable to run the Package. Following code i found on the internet which i have used as is ...
0
votes
1answer
392 views

Connect to SSIS from within Management Studio

A newbee question: Connect to SSIS from within Management Studio? I have a running service named: Integration Services 10.0, but from within Management Studio, I don't know how to connect to it, it ...
1
vote
0answers
55 views

Connecting SSIS to AWS RDS SQL Server Instance

I am trying to connect SSIS to an AWS RDS SQL Server instance. Whenever I try to run the packages through the SQL Server Agent, I encounter this error message: Non-SysAdmins have been denied ...
1
vote
0answers
97 views

DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

After moving a package to another server, I am unable to run it from a stored procedure using xp_cmdshell or from a job. The package exists in the file system, and I added it to the SSIS Package Store....
1
vote
0answers
60 views

What does this setting do when copying SSIS packages? “Duplicate package folder structure on destination for selected packages”

What does this setting do for copying SSIS packages? "Duplicate package folder structure on destination for selected packages." Is there any reason why I wouldn't want to duplicate the folder ...
1
vote
0answers
350 views

SSIS on W2K8 R2, SQL Server 2008 SP2 and Oracle

I'm in the process of migrating an old SQL Server 2000 SP4 on Windows 2000 to a new SQL Server 2008 SP2 on Windows 2008. In the old server we have a DTS that does some simple tasks against an Oracle ...
0
votes
0answers
18 views

SSIS Package stops SQL Server services

I built a SSIS package to populate Fact Tables. I came across a strange issue. So whenever i run the package/DFT task it results on failure. On inspecting it, i see that connection problem to the sql ...
0
votes
0answers
58 views

SQL Server 2014 SSIS job fails

I have an SSIS project that runs perfectly when I run it right off of the Microsoft Visual Studio editor. I need it to be a job in SQL SERVER 2014. I have created a proxy for it so that the same ...