I do have a friend who does contract work on SQL and will be moving to 2008 as soon as it goes RTM. There are a number of new features...

We don't touch new technology until it's proven and settled (a service pack or two) and passes the acceptance testing and also has good reason to move to. We are...

What about using a linked server to your other domain SQL box?

Yes, schedule it to run in a job.

SQL Server WILL only use what it needs but...

I have come to rely on the great information provided here to be able to do my job. As a result, I feel compelled to give back and write replies...

Have you tried using the File System task? May not be flexible enough but...

Or, you could use an Execute SQL task. The drawback with this is you have to have...

I believe you'll need to upload the file to a location on the server where the SSIS package would have rights to see. I would suggest uploading the files to...

32-bit vs 64-bit doesn't make a difference. In SSMS, when you click on Connect, select Integration Services from the drop-down and fill in your appropriate connection information.

I have always created a user for the vendor application to use that has DBO rights. Not from a standpoint of laziness but from the standpoint that the vendor application...

I don't know what the "technical" answer is but I can say that the client tools I'm using now installed from Enterprise are identical, functionally, to what I used with...

1) Is there anyway for me to trigger the creation of the SSRS report from SSIS as the last step of the SSIS process?

2) Have that report export its results...

If you are running them from within SQL Agent jobs, you can look at the steps to see where they are being run from. If they are being run from...

If looks like you should start with a DBCC CHECKDB to make sure the database is in good shape. Then, make sure you are at SP2.

Here is the link to...

Putting the query or script in a T-SQL step of a job has always worked for me in the past. I guess, however, a good question to ask is whether...