if you click the elipses button at the right of the expression property field for the variable, the expression builder will open up and you can use that to build...

unfortunately, i don't have any experience in creating unix files so this might be where i sign off.

i do know that you can switch column headers on or...

so that would imply that the query is working fine, but there is some problem writing to the file.

could you change the query and replace the single column with all...

when you say you preview the query, is that in SSMS or using a data viewer in the data flow? (apologies if these questions seem basic or pointless, but sometimes...

is the problem that the file you create is empty? have you check the data coming from the source using a data viewer?

are you hoping to make a comma separated file?

it's difficult to know without being able to see the sql itself.

tom

can you give an example of the query you are running?

tom

the For loop will manage the conditions needed to control the loop. In the For Loop section of the editor you have three properties: InitExpression, EvalExpression, AssignExpression.

InitExpression: this will...

if it were me, i would probably copy the row identifiers of the data being extracted into a separate, temporary data destination in the data flow, along side your main...

you could use a for loop to do all the hard work for you on this one.

you set the for loop to use a date as the limit, so you...

is this one of your original packages or did you inherit it? the reason i ask is that if you inherited it, perhaps the original coder made the db...

Do you need to know just of the existence of null entries in rows, or do you need to see the specific rows themselves?

If the first, you could use an...

Is your constraint from SEQ_Stage1 to SEQ_Stage2 set as an OR or AND constraint?

If this was me, I would probably put the script task and the the SEQ_Stage1 and SEQ_Stage2...

couldn't make sense of the error message. however, just a quick check: is the account that runs the package a proxy account?

tom