Viewing 15 posts - 46 through 60 (of 88 total)
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...
March 11, 2014 at 12:41 am
I've worked it out now, so I don't need help on how to do this.
December 16, 2013 at 3:15 am
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...
December 16, 2013 at 2:27 am
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...
December 16, 2013 at 1:07 am
So what do expect me to do instead? As not completely sure what to do now? Thanks
November 23, 2013 at 4:05 am
Abu Dina you must have replied when i was replying to the first response, it looks like your script works! Thanks
November 21, 2013 at 7:25 am
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...
November 21, 2013 at 7:23 am
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 =...
November 6, 2013 at 5:10 am
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)
September 18, 2013 at 9:06 am
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"
September 17, 2013 at 4:51 am
Hi,
Basically I need to know which of these jobs are connecting to which servers when the job step runs a T-SQL script or when running a ssis package?
Is this possible...
September 17, 2013 at 4:08 am
Hi IgorMi this will not work, thanks though!
September 9, 2013 at 4:57 am
Thanks dwain.c !
Exactly what I need, nice work!
September 9, 2013 at 4:57 am
Viewing 15 posts - 46 through 60 (of 88 total)