roblew,

I haven't used this with 2014 but I have used it with SQL 2008R2 which is also 64 bit so I know it works in that environment. I simply...

It was only written to help convey the idea behind the question. It's not production code.

It's been awhile since I posted this but I believe the second table tEmployeeStatus was used to maintain the status list so statuses could be added from a UI. You...

Jeff,

Thanks for that link too. I've updated all the iterations with your tally table method as well as other parts of the code. It's pretty cool to do it that...

Jeff,

I read the article. Much easier than writing a loop too. I'm not familiar with the FOR XML commands so I opted to do it a different way but still...

Jeff,

Thanks for the revised code. I really want to check it out now but I've got to get a few other things done first this morning.

I had the same problem of getting the dll to work with 2008. I'm in the process of converting a 2000 db to 2008 and I used that xp_NYSIIS a...

Yeah that's the next step in this package. Capturing the errors. Chapter 17: Error and event handling. 😀

kl25,

I kind of started to explore that option after you mentioned it. I'm not really familiar with event handling so it'd be good for me to goof around with it.

Elliott,

Thanks for the reply. I just ran across it in a test scenario. I'm using a script task to identify the file based on the content and then use conditional...

Phil,

That was it. I had to change the logical operator to "OR". Thank you both for the responses. I've read plenty about SSIS but have little experience with it. I...

Bob,

Yeah I agree. The issue I'm facing now is what is the best way to go about having our VB6 app process these files.

The scenario is this:

User downloads file from...

Kurt,

Thank you for the reply.

I read about a solution like that yesterday. They would map it and execute xp_cmdshell under a different user context. In some cases they would map...

Bob,

Yeah that was it. I updated the SQL Server account to a domain account and it now reflects that. Before it was running as Network Service.

Robert,

Thanks for the reply.. Back in the office so I just got a chance to give it a shot.

It's returning my actual server name that SQL runs on: servername$....