Access C# code from Integration services

I have an application in C# in which i have few events like download,Import and I have written all the code for that and its working fine but I have to schedule these processes so that I need not to run it manually daily. I am trying to write an Integration services package through which I could handle the required event, without rewriting the whole code.

Please Reply.

Thanks,

Pooja

bajaj.puja@.gmail.com

Hi Pooja B,

You can access a process (an exe file) with Execute Process Task - is this what you mean? If you just want to schedule the process maybe you could use "Scheduled Tasks" in windows.

Another aprouch is to ajust the code to fit into a Custom Task - how to do this is a little bit of work...

Regards
Simon
|||You can also use a script task to reference a .net assembly. Not sure exactly what you are trying to accomplish though, so I'm not sure if this is the right approach.|||

Pooja B wrote:

I have an application in C# in which i have few events like download,Import and I have written all the code for that and its working fine but I have to schedule these processes so that I need not to run it manually daily. I am trying to write an Integration services package through which I could handle the required event, without rewriting the whole code.

Please Reply.

Thanks,

Pooja

bajaj.puja@.gmail.com

Pooja,

See my reply to your previous post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1423350&SiteID=1

-Jamie

Access 2000 to Sql2000 : file size change?

I have an Access 2000 database with 640,000 records.
(growing weekly) File size is hovering around 245MB.
I plan to import/convert this database into a new database
on our SQL2000 server. (As soon as I finished that
chapter of the book!)
Implementation planning question: Will the database size
change significantly either way once it's imported in SQL?
TIA,
TeresaIt will probably me less than with Access.
When you import the access stuff, take a minute to check the column-type
definitions and optimize it for your needs.
You might also want to check indexing (wizard) when running on SQL2000 with
your applications, so you can provide propre and fast usage.
jobi
"teresa" <teresaj@.vvh.org> wrote in message
news:06c301c35550$497ded40$3501280a@.phx.gbl...
> I have an Access 2000 database with 640,000 records.
> (growing weekly) File size is hovering around 245MB.
> I plan to import/convert this database into a new database
> on our SQL2000 server. (As soon as I finished that
> chapter of the book!)
> Implementation planning question: Will the database size
> change significantly either way once it's imported in SQL?
> TIA,
> Teresa
>sql

Access - SQL Server 2005

I am trying to import a database from Access to SQL Server 2005 and it keeps failing. I don;t want to use anything but the simple screens Microsoft provides for Import/export. Any ideas on how I can make this happened?

- Prepare for Execute (Error)

Messages

Error 0xc0202009: {8A98B034-459D-4200-AD18-555244A05373}: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)

Error 0xc020801c: Data Flow Task: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task: component "Source 64 - DP_ROUTE_DRIVER" (6918) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)

I am also having issues with this as well

Im thinking it might have something to do with the 0x80004005. error

i did some research and possibly the user for the SSIS package doesnt have rights to the registry? according to http://support.microsoft.com/default.aspx/kb/295297

maybe it has something to do with access to the registry key.?

but i cannot figure out what would need access...

Im using sa authentication for the SQL server..

I am also running vista business ultimate and SQL2005 and Visual Studio 2005

|||

What version of Access are you using? If you are using Access 2007 you will need to use the ACE provider instead of JET 4.0.

Thanks.

|||sorry for delay of response

I am using 2003 ...my issue might have been to do with a corruption or error in the package that the wizard uses to do the import as i tried recreating the process again and it worked fine.. then i changed the script that gets built and this seems to be where the error is

Its like you cant do a custom script (even if it is the same script the system creates) with it..

ill post again when i come back on this project (prob next week)

cheers

Access - SQL Server 2005

I am trying to import a database from Access to SQL Server 2005 and it keeps failing. I don;t want to use anything but the simple screens Microsoft provides for Import/export. Any ideas on how I can make this happened?

- Prepare for Execute (Error)

Messages

Error 0xc0202009: {8A98B034-459D-4200-AD18-555244A05373}: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)

Error 0xc020801c: Data Flow Task: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task: component "Source 64 - DP_ROUTE_DRIVER" (6918) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)

I am also having issues with this as well

Im thinking it might have something to do with the 0x80004005. error

i did some research and possibly the user for the SSIS package doesnt have rights to the registry? according to http://support.microsoft.com/default.aspx/kb/295297

maybe it has something to do with access to the registry key.?

but i cannot figure out what would need access...

Im using sa authentication for the SQL server..

I am also running vista business ultimate and SQL2005 and Visual Studio 2005

|||

What version of Access are you using? If you are using Access 2007 you will need to use the ACE provider instead of JET 4.0.

Thanks.

|||sorry for delay of response

I am using 2003 ...my issue might have been to do with a corruption or error in the package that the wizard uses to do the import as i tried recreating the process again and it worked fine.. then i changed the script that gets built and this seems to be where the error is

Its like you cant do a custom script (even if it is the same script the system creates) with it..

ill post again when i come back on this project (prob next week)

cheers

Access - SQL Server 2005

I am trying to import a database from Access to SQL Server 2005 and it keeps failing. I don;t want to use anything but the simple screens Microsoft provides for Import/export. Any ideas on how I can make this happened?

- Prepare for Execute (Error)

Messages

Error 0xc0202009: {8A98B034-459D-4200-AD18-555244A05373}: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)

Error 0xc020801c: Data Flow Task: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task: component "Source 64 - DP_ROUTE_DRIVER" (6918) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)

I am also having issues with this as well

Im thinking it might have something to do with the 0x80004005. error

i did some research and possibly the user for the SSIS package doesnt have rights to the registry? according to http://support.microsoft.com/default.aspx/kb/295297

maybe it has something to do with access to the registry key.?

but i cannot figure out what would need access...

Im using sa authentication for the SQL server..

I am also running vista business ultimate and SQL2005 and Visual Studio 2005

|||

What version of Access are you using? If you are using Access 2007 you will need to use the ACE provider instead of JET 4.0.

Thanks.

|||sorry for delay of response

I am using 2003 ...my issue might have been to do with a corruption or error in the package that the wizard uses to do the import as i tried recreating the process again and it worked fine.. then i changed the script that gets built and this seems to be where the error is

Its like you cant do a custom script (even if it is the same script the system creates) with it..

ill post again when i come back on this project (prob next week)

cheers

About SQL Mobile Server

I need to export(import) data from Pocket PC(SQL Mobile Server) to SQl Server 2005(central data storage) in real time, if anyone knows how it would be better and faster to do...Maybe someone have done something like this...

Sorry for my English, I use it at first for last 6 years...)))

What's "real time" in your case? Also, since you have to have connection at all times for "real time" synchronization, why could not you use SQL Client to talk to SQL Server 2005 directly?

|||Do you have wireless connection between the central database and pocket pc?
|||

Sorry that I didn't answer erlear but for my headake list of my problems is very big...and know I hate peoples who write viruses .....

You See SQL Client...it's not best idea, cause I will have dial-up connect from Pocket PC to central DataBase (6-10GB) and I dont need to see it all..only several tables...and can upgrade them if it need..So I think that it better to make programm which will work with SQL Mobile Server..and then connect to central SQL Server and upgrade it...So I have a question...how it would be better to do...the component which syncronize databases don't work(it's writes that she need .net framework v 2.0.50727 or something like this i have installed .net framework...and so i don't know what is she want from me) It's my first expeerence in programming for Pocket PC, so something that is seem very easy for you for me is not...Sorry for my English...If you know russian it's would be easer for me to tell you what I need thank's!

|||

He says he is using dial-up to connect the Pocket PC with the server. So it would make the most sense to me to store everything he needs locally and only once in a while make a connection to the server to synchronize stuff (RDA or merge).

About that Framework message you get; apart from .NET CF2 did you install SQL Client 2.0 and SQL Server Mobile 2005 on your Pocket PC?

|||

I'll connect them throw Internet...

Thank's.

Sorry for my English.

|||

I think same...

I install full SQL 2005 Server and Mobile Server with native Client..So also think that if i synchronize databaseses they will updates once when connected if it needed.....

Sorry for my english...it's auful I know...

Thank's

|||

Tom v E wrote:

About that Framework message you get; apart from .NET CF2 did you install SQL Client 2.0 and SQL Server Mobile 2005 on your Pocket PC?

Now I dont use now real Pocket PC and this is the biggest problem..I emulate Pocket PC and Pocket OS.

|||

Hi,

SqlClient Vs SqlServerCe

SqlClient does not create any local database (that is SQL Mobile DB)

SqlServerCe would create a local database.

I recommend you to go through Merge Replication and RDA topics in our books online in detail to have a better understanding on how to get your job done.

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

About SQL Mobile Server

I need to export(import) data from Pocket PC(SQL Mobile Server) to SQl Server 2005(central data storage) in real time, if anyone knows how it would be better and faster to do...Maybe someone have done something like this...

Sorry for my English, I use it at first for last 6 years...)))

What's "real time" in your case? Also, since you have to have connection at all times for "real time" synchronization, why could not you use SQL Client to talk to SQL Server 2005 directly?

|||Do you have wireless connection between the central database and pocket pc?
|||

Sorry that I didn't answer erlear but for my headake list of my problems is very big...and know I hate peoples who write viruses .....

You See SQL Client...it's not best idea, cause I will have dial-up connect from Pocket PC to central DataBase (6-10GB) and I dont need to see it all..only several tables...and can upgrade them if it need..So I think that it better to make programm which will work with SQL Mobile Server..and then connect to central SQL Server and upgrade it...So I have a question...how it would be better to do...the component which syncronize databases don't work(it's writes that she need .net framework v 2.0.50727 or something like this i have installed .net framework...and so i don't know what is she want from me) It's my first expeerence in programming for Pocket PC, so something that is seem very easy for you for me is not...Sorry for my English...If you know russian it's would be easer for me to tell you what I need thank's!

|||

He says he is using dial-up to connect the Pocket PC with the server. So it would make the most sense to me to store everything he needs locally and only once in a while make a connection to the server to synchronize stuff (RDA or merge).

About that Framework message you get; apart from .NET CF2 did you install SQL Client 2.0 and SQL Server Mobile 2005 on your Pocket PC?

|||

I'll connect them throw Internet...

Thank's.

Sorry for my English.

|||

I think same...

I install full SQL 2005 Server and Mobile Server with native Client..So also think that if i synchronize databaseses they will updates once when connected if it needed.....

Sorry for my english...it's auful I know...

Thank's

|||

Tom v E wrote:

About that Framework message you get; apart from .NET CF2 did you install SQL Client 2.0 and SQL Server Mobile 2005 on your Pocket PC?

Now I dont use now real Pocket PC and this is the biggest problem..I emulate Pocket PC and Pocket OS.

|||

Hi,

SqlClient Vs SqlServerCe

SqlClient does not create any local database (that is SQL Mobile DB)

SqlServerCe would create a local database.

I recommend you to go through Merge Replication and RDA topics in our books online in detail to have a better understanding on how to get your job done.

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

About DTS Import Wizard

I use the DTS Import Wizard to copy one database to another. I notice that
it does the importing of tables and data alphabetically.
This causes some problems for me because I need some tables to be copied in
certain order due to the relationships and constraints.
Is there a way for me to use DTS Import but in the table order that I
define?
Thank you.Bob,
If the Copy SQL Server Objects task doesn't tranfer the tables in the order
required then try:
1. Create a DTS package and transfer the tables in the order required -
using presidence.
2. ALTER TABLE disable or drop the constraints prior to transfer then
recreate once the transfer is complete. The constraints can be scripted via
EM. Note: This approach requires that none of the data be modified on the
source or destination until the constraints have been reenabled or recreated
or the data may get out-of-synch and the creation of the constraints may
fail.
HTH
Jerry
"Bob" <spamfree@.nospam.com> wrote in message
news:uE%23Lkc50FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I use the DTS Import Wizard to copy one database to another. I notice that
> it does the importing of tables and data alphabetically.
> This causes some problems for me because I need some tables to be copied
> in
> certain order due to the relationships and constraints.
> Is there a way for me to use DTS Import but in the table order that I
> define?
> Thank you.
>|||Thanks Jerry.
I think the DTS package is what I need. Can you go through how I go about
creating a DTS package?
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eyBIbx50FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Bob,
> If the Copy SQL Server Objects task doesn't tranfer the tables in the
order
> required then try:
> 1. Create a DTS package and transfer the tables in the order required -
> using presidence.
> 2. ALTER TABLE disable or drop the constraints prior to transfer then
> recreate once the transfer is complete. The constraints can be scripted
via
> EM. Note: This approach requires that none of the data be modified on
the
> source or destination until the constraints have been reenabled or
recreated
> or the data may get out-of-synch and the creation of the constraints may
> fail.
> HTH
> Jerry
> "Bob" <spamfree@.nospam.com> wrote in message
> news:uE%23Lkc50FHA.2076@.TK2MSFTNGP14.phx.gbl...
that
>