solving sql server problems for millions of dbas and developers since 2006

SQL Product Highlight

Idera - SQL safe backup

Idera's SQL safe provides a high-performance backup and recovery solution for Microsoft SQL Server. SQL safe saves money by reducing database backup time by up to 50% over native backups and reducing backup disk space requirements by up to 95%. SQL safe also enables complete "hands-free" automated backup of your entire SQL Server infrastructure and ensures compliance with your organization's backup and recovery policies. From implementations with tens of SQL servers to enterprises with hundreds of servers spread around the globe, SQL safe is the only SQL Server backup and recovery solution that scales to meet the challenge.

Learn more!

Issue while running SSIS Package

Asked 1/30/2012 3:24:07 AM by Ajit

I am using Windows Server 2008 64 bit and SQL Server standard edition 64 bit. I have created a ssis package using save ssis package option (file system with package protection level do not save sensitive data )while running import utility to import excel file into syste. Import utility is working fine. After that I have imported that ssis package into integration services under stored packages --> file system.

After that when I tried to run this package it gives error message. After validating 33%, in next line error message shows

error ssis error code dts_e_cannotacquireconnectionfromconnectionmanager. The acquire connection method call to the connection manager "Destination connection OLEDB" failed with error code 0xc0202009. There may be error message posted before this with

Plz help to resolve thius issue.

Thanks in Advance

Answered 1/30/2012 7:51:15 AM by Jeremy Kadlec

(0)

Ajit,

Is the complete error mesage in your post?

Is there an error above what you posted that may be helpful to troubleshoot the issue?

Thank you,
Jeremy Kadlec

Answered 1/30/2012 9:24:41 AM by Raymond Barley

(0)

With 64 bit you either need the 64 bit drivers for Excel or you can use the 32 bit drivers and use the 32 bit version of DTEXEC.

Take a look here http://msdn.microsoft.com/en-us/library/ms141766.aspx for the details.

Personally I just use the 32 bit drivers and that works for me.

Answered 1/31/2012 2:32:37 PM by Ajit

(0)

Hello Jeremy Kadlec

When I execute the package. a package execution progress window open. And the message I have written in my issue is the 1st message. After that some other message are also there. I am not able to paste print screen of that message in this box.

Can you provide me your email id so i will send print screen to you.

Thanks

Ajit

Answered 2/2/2012 10:15:06 PM by Ajit	(0)
I have resolved the issue. Issue is I have made the ssis package with my user credential and I connect integration services with windows authentication. So when I execute the package it is not able to connect to destination connection string because of pwd was not there in the string..

Sponsor Information

"Amazing, Amazing, Amazing! SQL doctor is truly one of the most powerful tools I have seen."

It takes just 5 minutes to connect your SQL Databases to source control. Got 5 minutes? Get started now.

Need SQL Server help and not sure where to turn? Reach out to the Edgewood experts for a Health Check starting at $995.

Get SQL Server Tips Straight from Kevin Kline.

Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now.

Free web casts for DBAs and Developers on Performance Tuning, Development, Administration and more....