When I deploy a SSIS package I would do this in Visual Studio by clicking on File > Save Copy of

A new window would appear which would say "Save...

I am not quite sure? How would I know if the package is stored on the msdb or disk?

Thanks

How would you parse the XML? Do you have any sql code that would do this? Thanks

How would I know if the package is using a configuration? Where would I need to check to find this out and can I still amend the package to change...

I've worked it out now, so I don't need help on how to do this.

Just advice on how to do this?

Would I need to first select a distinct list of Orderid's then pass this to the foreach loop container?

Not sure then how it...

1. I need to create a ssis package

2. I want it to query the orders table for each orderid then for each result set it returns for each orderid to...

So what do expect me to do instead? As not completely sure what to do now? Thanks

Sorry not sure what u mean?

Abu Dina you must have replied when i was replying to the first response, it looks like your script works! Thanks

Thanks for this so far, it doesn't seem to have worked though? For orderNo "A1001" orderLineNo "8" I would expect that to show as "Some" because the whole orderNo is...

such an idiot, yes you have fixed it! lol! It should be the following:

Select

t1.warehouse,

t2.warehouse,

t1.product,

t2.product

From productOld t1 full outer join productNew t2

on t1.warehouse =...

I'm being thick, sorted it now:

Select

convert(varchar,convert(datetime,'2013-09-17 21:01:00.000'),103)+' '+convert(varchar,convert(datetime,'2013-09-17 21:01:00.000'),108)

Thanks I'll have a look into this

How do you do this?

Would you physcially have to open each ssis package in Visual Studio and then right click on the dtsx and then select "View Code"