Viewing 15 posts - 16 through 30 (of 49 total)
I am getting :
Server: Msg 195, Level 15, State 10, Line 2
'Coalsece' is not a recognized function name.
any thoughts?
July 8, 2005 at 9:58 am
I am not trying to change the value. I am trying to change the data type for the variable and it is not letting me. But I have worked around...
March 17, 2005 at 8:40 am
I have added a "Dynamic Properties Task" and created the following:
Destination Property Source Type Source Value
Value Global Variable AgentID
Value Global Variable Year
Value Global Variable Month
Value Global Variable Day
where are set to...
March 16, 2005 at 12:20 pm
I have tried that also:
dtsrun /S "MyServer" /N "myDTSPkg" /A "AgentID":"8"="13321" A/ "Year":"8"="2004" A/ "Period":"8"="07" A/ "Day":"8"="01" /E
and still get the same error. I also tried creatind another package...
March 16, 2005 at 10:57 am
wouldnt it be easier to have the sponsorID in the address table like Kathi Kellenberger suggested? then there is not need for a...
February 7, 2005 at 10:19 am
the way i was thinking of it is that a user gives me a start, end and due date. based on what the start and end date is I need...
February 7, 2005 at 9:56 am
it seems thats what is happening. I put the other stored procs in the DTS package to run in order. maybe that will work?!??!!
February 7, 2005 at 7:46 am
when i login as user1 and exec the stored proc in query analyzer i dont get any errors. i have print statements in the stored proc to print out the...
February 4, 2005 at 1:07 pm
Phill,
i am sooooooo confused now. So far in all my apps. I only have exec permission on the stored procedure for the user that is logging in. in all of...
February 4, 2005 at 7:46 am
I mentioned in the beganing of the post that the way the DTS is set up that the package will finishe even if there is files missing. meaning if we are...
February 3, 2005 at 3:07 pm
Grasshopper,
I am using user1/pass1 in my connection string. I have an user1 in my db who has permission to exe stored proc that I am calling. Also i m using...
February 3, 2005 at 1:53 pm
I am also having problems where I have a query that modifies a number of tables. one of them (A) has more then 2.25 million records. all the other tables...
February 3, 2005 at 8:35 am
Journeyman,
I ran the query in query analyzer and it worked perfectly. Thank you very much. I should be able to do:
insert into myTable(<fields>
<select...
February 3, 2005 at 8:20 am
NOCOUNT is set to default (OFF).
in the stored proc, I used the following line to call DTS:
EXEC master.dbo.xp_cmdshell 'dtsrun /S myServer /N myPackage /E '
should i set the NOCOUNT to...
February 2, 2005 at 3:19 pm
I didnt set the DTS package to produce an error log. but if there is any files missing (which happens often) then there is errors (file not found) but that does...
February 2, 2005 at 1:13 pm
Viewing 15 posts - 16 through 30 (of 49 total)