i have sorted this - it was exporting to an old .txt file format, hence not working.

more care, less haste!

all sorted. cheers Phil

thanks for the info. the issue i seemed to be getting was the file location were not recognised by the sql service account

i.e i had file location such as H:\location\etc...which...

Hi,

I have created the packages on SSIS. when i import onto integration services, the package runs ok.

When i try to create a sql sever job, the package does not run....

i have now tried setting up a job and uses the start job procedure .

The packages do seem to start but fail when trying to access folders to pick up/create...

this now works! thanks for the explanation. I have added two precedence containers (plus the script task ofcourse) and now it either sends an email saying no file is present...

thanks for the script. However, i really am at a beginner level on these things...

i have my foreach container but haven't figured how to actually assign the variable to the...

Hi

I have a similar issue to resolve i.e if no file, then send an email.

I have created my package variable (as int32) but am unsure as to what task i...

i should add i have now created a dynamic connection string...but just need to apply a loop criteria to check for the file.

that works- thank-you.

i am trying to get into a habit early on of using variables,parameters..hopefully better in the long run!

cheers

just tried that and its saying:

The data type "DT_WSTR" cannot be used with binary operator "&".

this works - cheers.