Due to waiting for answers to emails and for changes to the database server to be applied (exactly how long does it take IT Services to turn on SQL Server Agent???), I’m still waiting to complete the SQL Development work I started so many weeks ago. But I digress…
Part of the work is to create SSIS packages which I did using Visual Studio and then imported into Management Studio and ran them. Part of the package was to output the query to a file whose filename included todays date which is very easy to do using the Expression Builder (and this wiki proved very useful) but no matter what I did to the package it would run fine in Visual Studio, but when I imported it into Management Studio it would revert to using an old filename that I’d put in when I first created the package.
Quite a while later (being a bit slow today obviously!), it dawned on me to check where I was importing the new version of the package from. I had assumed that it was importing from the place that Visual Studio was saving to, but no it was using the SSIS folder where I’d exported a package with the same name much earlier. Doh!!! Changing to import from the file system and selected the new package and ta-da, it all worked! Oh what an idiot I am!
Note for the day – ALWAYS check the basics when things aren’t working!!
