Viewing 15 posts - 136 through 150 (of 179 total)
You might find this useful
Look for > Connecting to a Workbook in Excel 2007 Format
November 20, 2008 at 12:57 pm
You will need to use Execel Source in Data Flow Source & Excel Destination in
Data Flow Destination.These are available in the Toolbox.
November 20, 2008 at 9:19 am
Hi There,
I nvr did any Decryption with PGP in SSIS.
Im guessing you can pass the passphrase as an Input Variable to Execute Process Task.
This site might help you
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3978602&SiteID=1
October 28, 2008 at 8:56 am
After some playing around now I understand the logic of Expressions.
I got it to work.Thank You
October 27, 2008 at 2:44 pm
Changing to this argument and including some space,got it to work
--recipient "XXX" --output "C:\Testing.zip.gpg" --encrypt"C:\Testing.zip".
How can I pass the file names as variable's.I have 2 files to be processed with...
October 27, 2008 at 1:09 pm
Hi There,
Here is the current setup.
1) Installed GPG under my account
2) Test execution in command prompt with my account
3) SSIS package created by Me
4) Package excution done locally...
October 27, 2008 at 10:39 am
Anyone out there ever had a need to encrypt files using SSIS?
I have tried changing the arguments execte sql task to be
gpg --recipient "XXX" --output "C:\Testing.zip.gpg" ...
October 27, 2008 at 9:54 am
Not sure how big you files are but this as an Open Source
October 24, 2008 at 2:28 pm
I tried to add the below in arguments for my Execute Script Task.
It gets executed with no errors but It did not create a.gpg
Here is what I am passing,this line...
October 24, 2008 at 1:58 pm
Have you read this
http://www.sqlservercentral.com/Forums/Topic482799-148-1.aspx
Read All the way below
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1149752&SiteID=17
I was able to zip mine using winzip command line and wrote some code in Script Task to...
October 24, 2008 at 1:42 pm
Thank You Eric,
I shall try this right away.
Do I need to pass the passphrase anywhere in Execute SQL Task ?
October 24, 2008 at 6:22 am
All any of you guys know what Im missing in the argument in Execute SQL Task.
Im trying to encrypt a zip file
Arguments : XXX -encrypt C:\A_20081023.zip
(XXX refers to the User...
October 23, 2008 at 12:41 pm
Should the trace use Master db to run ?
October 17, 2008 at 10:00 am
This is what I have done.
Go to SQL Profiler > Create new Trace>
Specify Trace stop time and file name to save the trace to.
The Trace would start executing.Go to File...
October 17, 2008 at 9:48 am
Im trying right now.Shall update if I face any problems.
Thank You
October 17, 2008 at 9:28 am
Viewing 15 posts - 136 through 150 (of 179 total)