Brandie Tarvin (6/16/2011)

---

Why use a Script Task when a File System Task might work just as well? You can set variables at the package level and have them populated by...

mwinn (6/15/2011)

---

Thanks for the info, the last option only works on server express 2008 and according to the blog is not backward compatible. If I upgrade from Express (I have...

I'd start with the error log..

CEWII

Again, I would suggest starting a NEW thread, not trying to continue on with this one.

CEWII

SQLRNNR (6/15/2011)

---

It reads to me that one server is Express and that the other is a server.

Either case, you should be able to get SSIS to work by installing from...

That sounds pretty cool..

CEWII

I bet you that the DNS settings on one node do not match the other.. I've seen that cause what you are talking about. I've also seen organizations...

Unfortunately neither of those is available to you using SQL Express. Without either...

This is an old thread, I would suggest starting a new one.

CEWII

Well since we are talking about CTE's we are talking about at least what, 2005?

can't remember what version they were introduced in..

CEWII

jpSQLDude (6/15/2011)

---

Elliott Whitlow (6/15/2011)

---

Without trying to be snarky I have to say this was not well thought out..

As a necessary practice, not a best practice, but a necessary one, Dev...

I got a friendly nudge to come look at this thread and my first impression is this seems like a lot of work to work around a c# problem.. ...

I would probably use a script component for step 2, if you have more than one file I would probably output the list form a query or sproc into...

Without trying to be snarky I have to say this was not well thought out..

As a necessary practice, not a best practice, but a necessary one, Dev boxes for production...

Stringzz (6/14/2011)

---

Was there any determination on the query syntax?

Can you send your actual command, it looks like you were using the command from the article. I'm just wondering...