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

learn more… | top users | synonyms

4
votes
1answer
463 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
119 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
320 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
222 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
40 views

SSIS Execute from Job on server - Show Colors on package

We are running SSIS on SQL Server 2008 R2 I have a SSIS package that gets executed from a job on the server ever morning and it can take a few hours to complete. When you execute the package from ...
0
votes
1answer
1k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
0
votes
1answer
306 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
631 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
381 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
39 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
299 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 ...