SSIS object search using T-SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by James Greaves » SSIS object search using T-SQL

14 posts, Page 2 of 2

««1 2

SSIS object search using T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

Bill Boyer-284226

Posted Thursday, May 13, 2010 7:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 15, 2011 5:57 PM
Points: 1, Visits: 12

James - Thank you. We're just looking at transitioning from SQL2000 DTS to 2005 SSIS and this helped me understand. Since you work a lot with SSIS can you tell me whether you have found how I might call a SSIS package to execute from VBA? Perhaps by executing a stored procedure from VBA where that stored proc executes the SSIS package?
Thanks

Post #921716

Ed Zann

Posted Friday, May 14, 2010 6:57 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:05 AM
Points: 470, Visits: 1,054

Bill Boyer-284226 (5/13/2010)

Bill, if you are executing the VBA from the SQL Server then look into using DTSExec http://msdn.microsoft.com/en-us/library/ms162810.aspx. If it is from a remote machine, my approach would be to set up an unscheduled SQL Agent job to run the SSIS package. Then use sp_start_job to run the job. I think you will find that the SQL Agent and SSIS have been nicely integrated and it's easy to set up packages and run them in this fashion.

Post #921991

Maria Vogel

Posted Thursday, June 10, 2010 1:25 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 1:40 PM
Points: 5, Visits: 86

A number of our packages have XML that is encrypted. Is there a quick way to add decryption to these queries?

I've been playing around a bit, but haven't found anything yet.

Thanks!

Post #935672

James Greaves

Posted Friday, June 11, 2010 5:00 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 06, 2013 9:46 AM
Points: 280, Visits: 375

Maria Vogel (6/10/2010)

A number of our packages have XML that is encrypted. Is there a quick way to add decryption to these queries?

I've been playing around a bit, but haven't found anything yet.

Thanks!

I would turn on SQL Profiler and trace the MSDB database when a encrypted package is opening to see how the SQL engine decrypts the SSIS package using a function or something else.

Post #936366

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions