Have you deployed that package ? Have installed two instances of sql server one sql 2005 and other sql 2008 ?

Hi,

You cann't update the sql data adapter from other source i.e. access filled dataset(data table), just do some research on replacing or updating the dataset filled from access(oledb) data...

Just go ahead and upgrade .... Keep all back up in place before start ::-P

I can run the batch file on my server perfectly and got the result like if i run the command directly

just run the command directly using xp_cmdshell very simple...

There seems an issue with bat file, if you are bale to execute this then problem may lies with bat file

and can you also please let me know whether...

Does the account which is being used by sql service has read & execute permission on the bat file ?

--

Ashok

derekr 43208 (4/11/2012)

---

Like this:

declare...

Hi,

Remove quotes around any components in connection string in data source of the job's step, Will resolve your problem.

Regards

Ashok

Hi,

You can not pass parametes like this in the stored procedure, just concatenate the parameters in the local variable then assign it the subject or body.

Regards

Ashok

MarvinTheAndriod (9/23/2011)

---

When you install SQL server 2005 where is the option to change the default installation of system databases to another location ? I sure it must be there but...

Use Deployment method while running package in job,if the user/account is different from who has created the package and the user/account under which SQL Agent is running..

I hope this will...

whjat kind of authentication you are using for this.

Use Basic authentication while creating database mail profile and check that that account has right on the SMTP server to send the...

Ok, Share the scripts to create the table and test data. so that i can simulate the same on my machine, This would help me to help you.

Thanks

Ashok

Hi,

However there is no harm in having separate column for type and moreever you can have fix length of ID like xxyyyyyyyy where xx can be your type, this...

sam.alexander (8/31/2011)

---

You can loop through the directory using SSIS, which isn't too crazy to do, but if you're still learning SSIS and just need a quick and dirty solution you...