Does the stored procedure use a cursor? If so, are you deallocating it when you are through with it?

Does the package run an Execute SQL task and then a...

The new problem seems trivial. I had my columns out of sync. I just ran the package and it ran.

I have a number of Data Flow Tasks to...

Lowell, thanks for the help! I actually ran this command from the admin command prompt:

AccessDatabaseEngine.exe /passive

So on my 64-bit PC I put the 32-bit drivers in place. I...

Jack, thanks so much for the reply. It turned out to be from a long-forgotten package configuration.

I am very impressed that you solved it. I thought...

Well, if you keep all your querying logic in one place rather than splitting some of it off in SSIS, it makes it easier to find it later on. ...

I've said this before, so hopefully I don't come off as a broken record. However, I would never use derived columns in SSIS. Instead, I would use SQL....

Hey GilaMonster, I have set up Transactional Replication and I am totally loving it! It works like a champ. Thanks for the excellent suggestion. 😎

GilaMonster, thanks again for your insight. Based on your earlier comment I'm going to research Transactional Replication as it seems the best way to copy a production DB two...

Based on the opinions expressed here:

http://stackoverflow.com/questions/2043726/best-way-to-copy-a-database-sql-server-2008

The BAK file and restore method seems to be the preferred way to copy a production database during business hours.

GilaMonster, thanks again for the information in your reply. I am going to look into another way to copy a production database to another server so that the latter...

GilaMonster, thanks for the informative reply. I need to digest what you've written. Until I do, thanks!!

I am trying to get the log shipping going so that we can copy a production database several times a day for the purpose of doing reporting on the secondary...

Hi Steve, thanks for the tip. I changed it to "standby" and I now have a secondary database with all the tables I expect to see. Thanks!

GilaMonster, I...

Hello, I have abandoned this thread because I am no longer receiving errors with log shipping. Instead, the destination DB is stuck on "restoring..." The new thread is...

The problem has gone away. In my Data Flow, in the Excel Destination, I changed it from using the 'SQL command' to the 'table or view' option. Then...