Hi, I would like to remove first few commented lines before I load my text files into SQL table.

please tell me how to write code in SSIS (script task) to...

Hi, Koen Verbeeck

Yes I do have experience in SSIS, I am using SSIS since last 3+ years.

Thanks

Hi, did you find job? I am attending to interviews too, please let me know if you know any SSIS questions with answers, thanks in advance.

The easier and preferred method is to simply create a variable for the path and use get date functions. Click the connection manager for the output text file --> View...

if i create package from BIDS, I can see "execute task" option.

Some of them I migrated form DTS to SSIS, those if i open from BIDS, I can't see "execute...

hmm thats interesting, I don't have "execute task" and "edit breakpoints".

Thanks again

actually I am on control flow tab, if i right click on the step I do see "edit, disable............upto properties", but I don't see "execute step or execute task"

Thanks

Hi Grasshoper, thanks for your reply.

I already created SSIS package, but my question is how can i exectue individual tasks. If I want to execute just truncate table (1st step),...