Thanks for the script, hoewever it's hard to read. Perhaps include the script as an attachment to your article instead of putting it in a code block 😉

Hey guys,

Check out this website, will probably solve your issues with Hash Bytes within SSIS:

http://ssismhash.codeplex.com/

God Bless.

Yup, missed the semicolon...

Nice article, thanks for sharing Stan. I very recently sat with the same issue, and after some investigation into different solutions to the issue I decided to use Core FTP...

Great article! Very insightful and will definitely help with current and future developments. Ciao.

Hi Randy,

I've been looking everywhere for a solution to this but have found nothing. I'm wondering if a call should be logged with Microsoft to resolve this issue?

Kind Regards,

Ignacio

Hi CozyRoc,

Thanks for the reply. Yes, very odd behaviour. I'll look into loading the full user profile, and as soon as I find something I'll post it here.

I'm not working...

Hi Jack,

Looks like the user can only see the schemas that he / she has been allowed access to. Seems like the users will have to get used to looking...

Hi Jack,

I'll test it out and let you know.

Kind Regards,

Colin.

Hi Jack / Barry,

Thanks for the replies. OK, so there's no security risk, glad to hear that. From the inconvenience point of view: If I understand your replies correctly, users...

Hi There,

The issue I've picked up is that if you accidentally use a SQL Server Destination in your Data Flow Tasks and you have to change your Destination to an...

Hi Steve,

Great article. I agree that there are many times where you would really like to say what you want to the client / co-worker / boss, but the problem...

Hi Steve,

I'm pretty new to the SSIS Job Scheduling side of things and therefore I also need some help regarding passing parameters to an SSIS Package stored in a SQL...