Nope, same error message. I figure it's got to be a permission thing because it'll run on other DBs on the same SQL server. I keep coming back to that...

The syntax is not the issue. As I said (or thought I said), the function WILL compile against the "master" database on the server as well as another database. It...

I've got encryption working OK but now I am having an issue with decryption. Is there a way to send the passphrase to the executable? Using the execute process fails...

I'm using a VERY simple script that works to change my flat file connection path but can't get the syntax to set the DataRowsToSkip property of the connection. To change...

BINGO! I actually wasn't removing any spaces from the data, just creating a predicate to stick the data into 3 tables. But you're correct about LEN vs DATALENGTH. Switching to...

Hey all,

Also have wrapped raw_data with TRIM so there aren't any space issues. I'm still leaning towards the COALLATION issue because I just got off the phone with one of...

SJT,

Thanks for the response. I have added the group by and count. My real file is close to 3 million records so I made a smaller file of about 6800...

Would THAT be a valid example of when to put on the MS bashing hat?:D:D

I won't be opening multiple BIDS instances again, that's for sure. May take a little...

Crispin,

Got everything working (almost, still have some dynamic SQL to figure out) but it took another total rebuild of everything. Seems it's not a good thing to have 2 instances...

Thanks Crispin. But so far redoing it has brought back what I should have been seeing. Still some work to do but bug (and rat) free so far.

Joe B

So do I, it's just being rat-like and is buried somewhere.....

I've decide to scrap everything and start over. I do have all my notes and settings. Lets see where that...

Before we put on the MS bashing hat, I really suspect it is a user error.

Is the enumerator for each file? YES

Is the folder a valid path? YES

Is there prehaps...

Tried that. I even went back to the original package which was working and this package was a copy of. The ForEach loop is NOT returning a valid value although...

This makes absolutely NO SENSE!

The FileName variable NEVER gets populated from the ForEach loop container. The scope IS the ForEach container. WHY?

I have hard coded the SQL into the Execute...

Very simple package:

A ForEach Loop container with an Execute SQL task in it. Variable mapping in the ForEach is to User::FileName. The collection Folder points to a folder on...