Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
keropotter
Starting Member
4 Posts |
 Posted - 2010-05-27 : 11:35:11
|
| Hi!I've been surfing the web looking for the answer to this question with no success...I'm building a DTS package to export data from a table in my SQL Server 2000. I export the rows to an Excel file just fine. Thing is, when the count of the rows is grater than 65536 (the amount of rows Excel supports), I need to change the destination and export the results to an Access file insted of an Excel file. The determination of the count of rows is done previously with an Execute SQL Task and stored in a Global Variable.So what I need some help with is getting my Data Transformation Task to switch between excel and access depending on the value of that global variable.I appreciate any help you can provide me with.Thanks in advance!Alejandro |
|
|
|
|
|
Export selecting Access or Excel dynamically