November 29, 2004 at 5:06 pm
How can I
1. get a "Transform Data Task" properties to insert data into a "password protected" Excel file ?
OR
2. automatically add "xyz" as the password after the data has been inserted ?
November 30, 2004 at 12:50 am
Sorry, I don't use DTS, but http://www.sqldts.com is a frequently referenced source for such questions. Maybe you find something there.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 30, 2004 at 4:07 am
Hi,
You cant access an existing password protected Excel file as it is encrypted.
You will be able to get around this by using an activeX script task to create the file, then pass data into it, then use another activeX script task to password protect the Excel file.
Have fun
Steve
We need men who can dream of things that never were.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply