March 24, 2011 at 9:39 pm
Please help error : Could not load package "\File System\XXXXX" because of error 0xC00160AA.
This is my Code
exec master..xp_cmdshell 'dtexec /DTS "\File System\Financial_ETL_System\ETL_OLTP_STG_Activity" /SERVER "[CK-6072443]" /CONNECTION "10.1.2.91.CK_DWHS.ckdw";"\"Data Source=10.1.2.91;User ID=xxxx;password=xxxxx;Initial Catalog=CK_DWHS;Provider=SQLNCLI10.1;Auto Translate=False;Application Name=SSIS-ETL_OLTP_STG_Activity-{C9271913-6DD2-46A2-B099-2E8166D1631F}10.1.2.91.CK_DWHS.ckdw;\"" /CONNECTION "10.30.62.48\SQL2008.CK_Staging.sa";"\"Data Source=10.30.62.48\SQL2008;User ID=xxxx;password=xxxxx;Initial Catalog=CK_Staging;Provider=SQLNCLI10.1;Auto Translate=False;Application Name=SSIS-ETL_OLTP_STG_Activity-{17E1ED81-39AE-4AD5-BF28-F4FDC5D89CD5}CK-6072443\SQL2008.CK_Staging.sa;\"" /CHECKPOINTING OFF /REPORTING V '
Error :
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2531.0 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 10:40:30
Could not load package "\File System\Financial_ETL_System\ETL_OLTP_STG_Activity" because of error 0xC00160AA.
Description: Connect to SSIS Service on machine "[10.30.62.48]" failed:
The RPC server is unavailable.
.
Source:
Started: 10:40:30
Finished: 10:40:43
Elapsed: 13.328 seconds
NULL
Please help
Thx
March 24, 2011 at 11:47 pm
For future reference, please scrub your information before posting. It looks like you posted the sa account and password in your command output.
As for the error, either the RPC server is failing or the SSIS service is not running on the server. Check services.msc to verify that both RPC and SSIS are running. Then check your system application log for further errors.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply