December 22, 2011 at 4:38 pm
Hi all,
I am getting an error at the "Execute SQL Server Agent Job" step. When checking the log I can notice messages like:
"There is already an open DataReader associated with this Command which must be closed first."
I am trying to copy 5 Databases and this message happens on all 5.
The source server is Windows 2008 Standard R2 32bits running SQL Server 32bits. The target server is Windows 2008 Datacenter 64bits running SQL Server 64bits. Could this OS difference (32 and 64) be a problem?
There is nothing in the destination server, I mean, no database. I am keeping the original database names. My intention is to create a copy of these databases to setup a Replication scenario.
Any help is appreciated.
Mario
December 22, 2011 at 11:54 pm
Can you describe the SSIS package to us?
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply