473,503 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Export/Import SqlServer 2005 c# (SSIS?)

Hi there,

I'm trying to figure out to to invoke the SqlServer 2005 Import/Export
wizard programatically.

I.e. Export DatabaseA.TableA to DatabaseB.TableA

SqlBulkCopy seems nice but my destination table is not always SqlServer.
I'm guessing I can use SSIS/DTS somehow?

Has anyone done this b4?
Can you provide me with a link to a sample?

Any help appreciated,
Tnx
Aug 2 '06 #1
0 1238

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
5266
by: stant | last post by:
I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of parameters (6) are fine. I've tried casting and still have...
2
6341
by: mattc66 via SQLMonster.com | last post by:
I have data that comes from a legacy system. I can obtain the data in an ASCII format. Currently I have created scripts in ACCESS to import the data into tables. What I would like to do is...
1
4009
by: Mindaugas | last post by:
I'm trying to help a client export some data from SQL 2005 to an Access database or even an Excel file. Either way I get an error like this: - Setting Destination Connection (Error) Messages...
1
9264
by: SQLNewbie | last post by:
Hi all, New to SQL Server - trying to create an SSIS package that will look for and import a series of Visual Foxpro tables (.DBFs) when they appear in a folder. The tables are/can be all...
1
5774
by: Eric | last post by:
In MS Excel, the ability exists to run a "web query." This function is accessed via the data menu's import external data option. The web query wizard accepts a URL address, and then is able to...
2
3407
by: othellomy | last post by:
What are the ways to export/import data in/out of SQL Server 2005? I used to use DTS for 2000 to do such thing and now I can't even find the wizard in 2005!
1
2431
by: info | last post by:
How import database mysql to mysql server 2005? -- magix
12
1999
by: joaotsetsemoita | last post by:
Hello everyone, im completly new to vb.net and I was assigned to do a simple piece of software that just had to select from um db in a MS access data base and insert into a SQL server Database....
3
7126
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this...
0
7063
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7258
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6970
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5558
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4987
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3156
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3146
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1489
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
366
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.