| |

VerySource

 Forgot password?
 Register
Search
View: 766|Reply: 5

Using ssis, through Datareader source and oledb target (sql server target), write the result to 0 rows

[Copy link]

1

Threads

4

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-1-24 08:00:02
| Show all posts |Read mode
Using ssis, through Datareader source and oledb target (sql server target), write the result to 0 rows
Tried it over and over again, it didn't work, depressed.
Tried to modify the timeout, etc., did not work.
Please master finger.
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-2-9 16:45:01
| Show all posts
Be clear, what's the problem with not understanding
Reply

Use magic Report

0

Threads

211

Posts

108.00

Credits

Newbie

Rank: 1

Credits
108.00

 China

Post time: 2020-2-9 19:45:01
| Show all posts
Did not understand what it meant
Reply

Use magic Report

1

Threads

4

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-2-11 00:00:01
| Show all posts
sorry, specifically:
Use datareder to connect to the sybase database through ado.net's odbc data source.
The data is then imported into the sql server database via the oledb target.
There are no warnings after debugging several times, but the data is always written to line 0. The write was unsuccessful.
Thank you
Reply

Use magic Report

1

Threads

4

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-2-11 08:30:02
| Show all posts
I am now trying to use an oledb data source. See if it works, install the ase oledb driver for the sybase client.
Reply

Use magic Report

1

Threads

4

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-2-11 11:00:01
| Show all posts
Using oledb as a data source I have been unresponsive when previewing data or selecting columns, and it is estimated that sometimes it is more aggressive and depressed.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list