spent almost 1 hour found out i had double quotes around path

sorry for late reply mate and thanks for your answer.

so if i have int as my contactid in db and storedprocedure should i pass this as long to exeecute sql...

that is exactly what i am doing. contactid is int in database.

the email part works fine after getting this object i am inserting some data to a table as my...

it is quite complicated package i need to send emails using contactids. so i have got a query to select these contact ids and assign them to an object variable...

Ok so let me clarify. i think i have found the error.

i am getting the contactid using a sql statement from another table and passing that as object in...

Hi Guys,

the above code worked. i am trying to get the contactid in object then convert to int32. but if for instance the package fails then it keeps on failing,...

basically the id is already in other table and is foreign key in the C table. all i want is to have same id as my parent table i have...

i did find this but http://www.sqlservercentral.com/Forums/Topic462732-148-1.aspx

but it is not what i am looking for. i want the data to be send exacltly as you execute in sql server.

please...

anyone on this please it is urgent!!!!!!!!!

or if you want a copy just create a execute sql task and write sql query like

select * into b

from a

thanks i did this. but now i want the filename to change according to date everytime the package is run(which is daily). i have added a script to change filename...

^^Anyone on this one please it is urgent

yes they do have the licence.

but when i open it with dev version of 2008 i get this error: mvs is unable to load this document. install integration service.

then i...

and another called enterpirse

it is actually my company's one. it just says sql server 2005 service pack 2 and another says developer edition??