If the file extension is incorrect then you will likely get no files to process. In that case the F-E-L will complete successfully and move to the next component....

I think he might just have been saying "me too"..

Not sure..

CEWII

2 possible things come to mind..

First, did you start SSMS by right clicking and saying run as Administrator.

Second are you logging into SQL as a trusted user or...

What is the logic inside the cursor?

Also do this as a rbar action is going to cost significant performance. Your question is why does the query only take 3...

Google Search for: crc32 algorithm vb.net

Yielded: http://www.vbaccelerator.com/home/net/code/libraries/crc32/article.asp

CEWII

It won't release memory until the instance of the package completes and unloads. When you call a package from a package both packages exist in memory, because package 1...

Well that does make things a bit more complex..

Ok, this solution will not perform as well as my first thought, but will still perform pretty good.

Write a sproc that takes...

I'm wondering if perhaps the application is looking for a different version of the Excel file.

When you open and save it again, what version of Excel are you using? ...

SQL Agent will only have a single instance of a job running. If a schedule overlaps then the schedule that should have been run will be ignored.

It sounds like...

Can I ask a question first? Are you primarily an application developer? I ask only because the method you have described is very procedural. And I think...

I happen to agree that this is not a replication scenario but is an archive/audit scenario. It is likely possible with replication and transactional replication with custom sprocs was...

The DTS files can be in either the SQL Server OR the filesystem. That shouldn't be an issue either way.

When DTS packages are saved into SQL server they are...

I know this is a stupid question but I'm going to ask anyway.. Have you applied the latest service pack?

CEWII

My first thought was to verify the input parameters and make sure all the types are right. I think the input mapping for XML should be string. And...

Q1. It just isn't, deal with it. Sorry, there really isn't a technical reason I can think of just MS doesn't support it.

Q2 & Q3. The easiest way to...