I have previously posted a question yesterday and thank you all for your quick response.

I’ve nearly completed the SSIS package but unfortunately it stalls(doesn't error and have left it...

Cheers guys the conversion task worked a dream.

In relation to SCC Rookie's comment "just go to the advanced tab-> output column and change the datatype" where should i be looking...

Ok. You are a star.

Mayber one more thing is that the best book to get ?

If so you know a link i can get it from tonight so i can...

Cheers i give that a go. By the way still using matrix ?

Lee

Sorry if i'm not clear enough.

I tried to use a matrix, have the typeid at the side and the month part at the top. so that ti could have the...

Whoop Whoop !!!!!

Worked Perfectly !!!!

Thank you very much.

http://www.mydatabasesupport.com/forums/ms-sqlserver/357322-excel-template-required-export-ssis.html

This guy has more or less the same issue i'm having. I will look at what his done.

Cheers for this.

Guys could you help me with the next step in my SSIS package. Am using the first part to create my folders but i want to use...

Didn't reliase i could just use this as the variables vale = /gets/*.zip

Is there any disadvantages to this ?