Viewing 15 posts - 10,801 through 10,815 (of 13,878 total)
Use Execute Package tasks instead?
April 12, 2012 at 5:43 am
If you have it installed somewhere, you could fire up Profiler and check the actual queries that are being sent from the front-end app. Might give you some clues.
April 12, 2012 at 5:21 am
slpgma (4/11/2012)
Not so sure that's a good idea for anything other than practice. If you did that in Bristol, RI, you're code would really be a problem because half...
April 11, 2012 at 5:35 am
aarionsql (4/10/2012)
Many thanks! Thank you I have learned a new way of thinking and looking at things when I saw your reply. I will try and replicate your query...
April 10, 2012 at 9:09 am
OK - do you have SSIS installed on both servers? Merely executing the command line is not sufficient.
April 10, 2012 at 9:02 am
Here's a CTE example:
with Table_A as (select 10844 x_No, 2 Rank2, 18178 sysno, 1 Rank1
union select 10844, 4, 27529, 2
union select 10845, 1, 22994, null
union select 10845, 3, 22129, null...
April 10, 2012 at 8:29 am
DBAgal (4/10/2012)
April 10, 2012 at 8:04 am
EasyBoy (4/10/2012)
preetham gowda (4/10/2012)
I did try converting Char to Varchar but getting the...
April 10, 2012 at 5:15 am
njdevils39 (4/9/2012)
By the way, I also do not work yet or get paid. I am an unpaid intern learning to advance my programming knowledge.
You're receiving high-quality, free assistance and advice...
April 9, 2012 at 12:48 pm
subha V (4/9/2012)
Im running my package using a command file.When im executing the package manually by clicking the command file,its running fine.
But when im trying to run the package via...
April 9, 2012 at 8:46 am
mdkmohan (4/8/2012)
I just need to disable sql jobs during holidays.
I found few ways for doing that but I don't know which is more efficient and generalized method.
Kindly provide your suggestion...
April 8, 2012 at 9:23 am
sivag (4/7/2012)
April 7, 2012 at 2:48 am
bharatgi (4/6/2012)
the key field is a concatenate of LocalID + DSeen + POD
Hmm, clearly not, as you have duplicates 🙂
I'm therefore guessing that this table does not have a PK,...
April 6, 2012 at 6:15 am
Viewing 15 posts - 10,801 through 10,815 (of 13,878 total)