Tagged Questions

0
votes
1answer
201 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 ...
1
vote
1answer
749 views

The package failed to load due to error 0xC0011008 Error Loading from XML

Environment: Windows Server 2008 SP2 Enterprise Edition 64-bit SQL Server 2008 SP3 Standard Edition 64-bit Previously had SQL Server 2005 Developer Edition 32-bit Integration Services. That has now ...
1
vote
1answer
62 views

Edit SQL Server SSIS Package

I ran the Export wizard to output some data to Excel, and I saved the package to run agan later. I now want to edit the SQL used to generate the Excel, but it is not clear how I do this. The package ...
0
votes
1answer
850 views

Export Import error 'SSIS Data Flow Task could not be created' … registering DTSPipeline.dll, cannot create task “STOCK:PipelineTask”

I'm about to throw in the towel on this one. Running SQL Server 2008 enterprise on Windows 7 x64. Can't get past this issue. When I try to Import / Export Data from databases through SQL Server ...
0
votes
1answer
320 views

SQLServer2008 CopyDatabaseWizard Job Fails - Unable to determine if owner of job has server access

Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in ...
2
votes
1answer
446 views

Execute SSIS package from a SQL Agent on another server

Here's my situation: I have two servers, Server A has the Database Server installed and the SQL Agent (SQL Server 2008 Enterprise Edition, 64-bit). Server B has a vendor specific application that ...
2
votes
3answers
15k views

Installing ONLY SSIS and not the whole SQL Server system?

I have a production SQL Server 2008 running on Windows Server and I do testing and development on my laptop. My laptop is running Win XP and SQL Server Express 2008. In addition to having SQL Server ...