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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 log in package

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-11-09 : 12:47:08
hello,

in DTS (SQLSERVER 2000), i can see the package log (in properties in each DTS).
how can i do it for package in 2005(SSIS)?

how can i export table to file in format "fileName.dat"?

thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-09 : 12:52:19
for implementing package logging see below

http://msdn.microsoft.com/en-us/library/ms138020.aspx

For exporting table to file Use a data flow task in SSIS with OLEDB source and Flat file destination.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-11-09 : 13:55:00
i know this article,it is very boring.
in dts it was very easy.

when i make a job. i do not know why in step (4-example) it faild.
how can i add a log for it?

seconf question:
can i export to ".dat"?
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-11-09 : 13:56:27
and how can i see this log,after execute the package?

thanks
Go to Top of Page
   

- Advertisement -