Thanks for the responses, the package is housed in our Dev-environment and one of the data sources is from a production box, so I am not permitted to grant the...

Thanks SA and Krishna.

Going back to amira's original post: "MSP Error: 29534 Service 'MSSQLSERVER' could not be started. Verify that you have sufficient privileges to start system services. The error code is...

Thanks Chris,

That worked, I did not have any additional calculations, so I cast each row and it worked.

Thanks,

DK

“Double check the time when the job runs. Is it possible it's running after the table has been truncated?”

I scheduled my job to run at 5:00pm, EST. The stored...

There are definitely results each day because I end up running the above-mentioned script manually without the Begin and Commit transaction. The query I posted at the onset returns about...

Thanks Erik,

That works for me!

Thanks again,

DK

Thanks Kyle, that worked.

Thanks for the input Prasad. Completed without problems.

Thanks Steve and Gail, for the replies,

David

Thanks for the quick reply. Do you mean separate file directories across a raid or SAN?

I believe you are referring to group domain accounts? If that is the case, from a basic point of view you will need to create a network group and include...

Are you looking for SQL Server DBs or any DBs, and by "servers" are you including non-database servers in your search, i.e... File servers?

David

Made a change to the System DSN and the problem appears to be solved.

Thanks,

DKlein

Thanks Toolman,

We ended up using F2. I used the standard formating link to test different formats.

Thanks for the help,

DK