It was a post by GrumpyDBA that caused me to post my first and only blog on here a long time ago. Now I am posting this entry because I am feeling like a grumpy DBA.

 My current client - a government agency who takes money off everybody (that should identify them Big Smile - I have a mortgage to pay) has a lab for testing new analysis software. They wanted some manual processes automating which included movement of file data around for processing by various applications. Well, I hadn't previously looked at SSIS in great depth as I hadn't really had the requirement to, so I thought here's my chance to get some experience. Well, all I can say is come back DTS - all is forgiven.

 I will give it it's dues, some things are good, but there is a lot of bad. In fact, every way I am turning at them moment I am encountering bugs, "features" and "by design". The latest being this https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=252471

so I thought I would work round it, exclude the two tables that had this issue (going to script them seperately outside the wizard as indicated), and then another table failed that does not meet that criteria in any shape or form.... So onto SSIS, using the transfer SQL Objects component. Well, failure after failure about creating an account that already exists - even though I hadn't select the security options....

I have also been hit by issues of file permissions after detaching databases - link to the secure FTP site and password is sat in my inbox for me to get the hotfix although I have worked round it using SUBINACL

 I feel really guilty, my next gig starts next week - hopefully the main one will be completed by then