It should work without issues, just make sure you make a full backup of the database before, wouldn't be the first time a file gets corrupt while being copied to...

well if you visit the Microsoft Certification Planner (and are logged in with your MCP Account)

you get a view like this:

if you then go ahead and...

Nowadays I hardly do any SQL Server Setup anymore, customers usually provide a SQL Box as they wish to have by own policy. I mostly do some fine tuning around...

I think that article is nothing else than a marketing stint for someone trying to sell some C-Level book. If you're happy with NoSQL or even just Flat Files (arguably...

if you scroll down that link you provided and expand "Step 2: Exams" you will see a list of courses that you can take in order to get your MCSE...

I solved my own issue with this by having the SQL Server Service Account run as a Domain Account or at least have an execution account with permissions on the...

Thank you, will do. Meanwhile I think I sorted my Script Task issue: It's nice to use a Proxy execution account when looking up on a Network path, especially if...

You're right, it's a Script Task, not a Component. Not entirely sure how the variable should be coming from the FEL, as the first thing that's needed inside the loop...

yeah in the Flat File Connection I have defined as Expression ConnectionString @[User::VarFileName] which seems to work. Just the Script Component which retrieves the values for the variable is still...

Probably the best thing I've done is not pursue that degree in 'Computer Networking BSc', as soon as someone explains to me why I need Java for this, I might...

I don't see the issue with the FEL but inside the loop is a flat file source which needs a complete filename passed, it doesn't like * inside.

This particular folder gets every day a new file with file_yyyymmdd.txt, previous days are being removed before a new file appears in that location. There's a separate Archive folder which...

Ok, sounds good. however I haven't managed to make use of the FLC to do just this (2) so I'm trying to solve it by a Script Task. I can...

Thanks for the confirmation, it did work today and I hope tomorrow it'll pass a different value 😉

I'm actually not sure why (someone passed this half way...