>I am trying to export data from SQL 7.0 to Excel through
>I tried the sample given in SQL
>I was able to export between two DSNs of SQL database,
>but failed to export from DSN of SQL to DSN of Excel.
>Can some one help me out.
>I tried to specify the XL file connection object without giving
>the DSN but I couldn't find the "file connection" object in
>Thanks in advance.
Create a package that does what you want, then use ScriptPkg to get the
Q. What is ScriptPkg and where does it come from?
A. ScriptPkg is a small utility written in Visual Basic 6. It can
be found on the SQL Server 7 CD-ROM or on your PC, if you selected to
install the Development Tools. Run the self-extracting archive
\mssql7\devtools\samples\dts\dtsdemo.exe, then look in the new folder
ScriptPkg loads a package and generates Visual Basic code to re-build
the specified package. It is very useful in understanding the DTS object
model, as you can compare properties set in the designer with the code
produced. Using this knowledge you can then dynamically alter Task and
Connection properties at runtime making your packages more flexible.
The SQL Server 2000 DTS Designer has a new Location "Visual Basic File"
from the Save As dialog which performs the same function as ScriptPkg,
but produces neater code.
Applies to SQL Server versions : 7.0, 2000
FAQ Categories : DTS
Related FAQ articles : n/a
Related Microsoft Kb articles : Q239454
Other related information : n/a
Authors : Darren Green
SQL/DTS - http://www.swynk.com/friends/green/