Thanks for posting the solution.

That seems to be OK.

Thanks for posting the solution.

sqlfriends (2/13/2012)

---

Once a while, I need to make a small changes on an exiting package on the server.

I usually open the .dtsx file, and edit and save it.

It works...

Jeff Moden (2/13/2012)

---

As a side bar, it's a real waste to have columns for zip codes (for example) to be set to 255 characters in width. You might want...

Do you have any error messages?

Try using the data conversion component to align metadata.

Are the sources and destination SQL Server? You might want to consider writing it all in TSQL.

My guess is that DTS is pointing at a different server.

If there isn't a linked server, then DTS...

Please do not crosspost. It wastes people's time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1251161-148-1.aspx

Did you run the Upgrade Advisor?

It might be a shot in the dark, but according to Supported Version and Edition Upgrades

, the evaluation version of SQL 2012 isn't mentioned in...

Watercooler? I thought...

That's odd.

Are you sure that nothing was blocking the sp at the database level when you executed it?

Can you browse the cube in BIDS?

naiduvamsi467 (2/13/2012)

---

i did tried to use script task but as i am new to ssis couldn't find the way to solve it, is any one there to elaborate on this...

Evil Kraig F (2/12/2012)

---

Thanks. I was concerned that I wouldn't explain the components well enough. Hopefully the scenario is clear and this doesn't...

I'm not really experienced in configuring MSDTC, but I found this article:

Troubleshooting Problems with MSDTC

What always should work is encasing your dataflow into a SQL transaction. This article explains the...