I am getting :

Server: Msg 195, Level 15, State 10, Line 2

'Coalsece' is not a recognized function name.

any thoughts?

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...

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...

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...

wouldnt it be easier to have the sponsorID in the address table like Kathi Kellenberger suggested? then there is not need for a...

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...

it seems thats what is happening. I put the other stored procs in the DTS package to run in order. maybe that will work?!??!!

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...

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...

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...

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...

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...

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&gt

<select...

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...

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...