i extracting data file daily , adding timestamp activedate column capture when particular record imported.
earlier using getdate() realized not accurate solution us. fortunately filename has datestamp (something xyz 12232015).
can import date date datatype field in excel? not sure how in sql server considering file saved on shared drive. file moved archived folder after ssis package sql code runs.
in ssis can using derived file transformation.
Comments
Post a Comment