Sched SSIS Package assistance

Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Rick.Bogholtz Grasshopper Points: 11 More actions · Answer 1

Try this link. It worked for me.

rothj Hall of Fame Points: 3531 More actions · Answer 2

Thanks for your response.

I do not believe my issue is permissions based.

I did try a proxy account and got the same error.

Good idea to try that, thanks. (especially since it works within BIDS)

Pretty sure my issue is the table already exists and the package is trying to create it.

I thought using an insert query (not Select Into) would work.

I didn't really want to drop the table but I guess I could try that instead of truncating it.

rothj Hall of Fame Points: 3531 More actions · Answer 3

Nevermind.

It helps when you chose the correct package to run.

I'd picked an old version in the the SQL Agent job. DOH!

Thanks

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

Have you traced it to see what is actually being sent to the database?

CEWII