-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: meher666
Message 2 in Discussion
New Message on MumbaiUserGroup
SSIS Services
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
meher666
hi all,
I am using SQL Server 2005. I created a SSIS package which copies data from
SQL Server to Ms Access database and schedule the package using a job to run
every week using SQL Server agent.
All this works fine, when the job runs for the first time. But during the
second week, the job fails. It says the table already exists in mdb file.
So to avoid this problem, i wanted to create a new MDB file and populate the
data accordingly.
Can anyone tell me how to do this. It will be of great help.
I have created the package using DTSWIZARD.exe
Thanx in advance,
rgds,
Meher
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
