You could do that with a DDL trigger on the CREATE_DATABASE event. However, can I ask what the purpose of this is? I'd like to understand what is...

Ok, lets work our way through the error..

Do you have the connection set correctly in the General tab?

Does it point to the right database?

Are your variable to input parameters mapping...

I am questioning the entire methodology. It sounds like the only difference is the connection string and the packages are being called from SQL Agent.

Why not use the options...

I would say yes. SSIS will be faster for most data movement tasks. It was built for that. I would be willing to bet money you can't...

I generally agree with da-zero. Packages should be designed in such a way that they work in ALL environments. This is usually handled by config tables or files....

There are substantially better ways to accomplish the goal. Can I ask how the packages are called? SQL Agent perhaps?

CEWII

I don't have a solid answer but I will give you these links and you can see if they fit.

SQL 2005 Pricing and Licensing FAQ

http://www.microsoft.com/sqlserver/2005/en/us/pricing-licensing-faq.aspx

SQL 2005 Special Licensing Considerations

http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx

CEWII

I don't know this as fact but I think you'll probably have to do it manually. Also, some of the 2005 components seem to be compatible. But I...

I think that kind of defeats the purpose of what was being asked.

CEWII

I agree it bites.

CEWII

Because you mentioned it was a "template", you didn't happen to set it as read-only in the file system? I ask because I've done that..

CEWII

Please see:

http://www.sqlservercentral.com/Forums/Topic748728-146-1.aspx

CEWII

Here is the problem. DNS resolves a name db.domainname.com to an address 10.1.5.50, this does not imply any port or anything else. Given this, DNS alone cannot do...

I think there is also something else to consider, a step failing isn't necessary a package fail, there are options to make it so. If you don't have a...

Yes, I have. When you renamed the file it asked you a question. Do you want to rename the object to match the name. I bet you...