T-SQL

Question

Post reply

T-SQL

Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

It looks a lot like you are protecting some code from public view, but getting it wrong?

Originally, your parameter @ID was an int, now it seems to be a varchar...

How about you just change it to print the variables @TaskOutFile and @SQLQuery so you can see what is in them, then correct it?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

mtz676 SSCrazy Eights Points: 9261 More actions · Answer 2

mtz676

SSCrazy Eights

Points: 9261

October 15, 2013 at 7:23 pm

#1658771

I got the code working properly.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Glad you got it working. You should still look at rewriting your process without using the Web Assistant tasks as those procedures are deprecated and your current process will not upgrade to future versions of SQL Server.

mtz676 SSCrazy Eights Points: 9261 More actions · Answer 4

mtz676

SSCrazy Eights

Points: 9261

October 16, 2013 at 11:22 am

#1659018

Yes,I do plan to get it done using SSIS and SSRS.

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 5

sqlserver12345 (10/16/2013)
Yes,I do plan to get it done using SSIS and SSRS.

Great. If you have any question on those technologies, don't hesitate to ask.

(I'll answer the SSIS ones :-D)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

T-SQL

Cookies on SQLServerCentral