shank,

Change the package security to "EcryptSensitiveWithPassword".  Click on an open area of the ssis control flow tab and then go to the Properties window.  There is a section for package...

I would set up a stand-alone table with these columns: tick1, tick2, tick3, etc

Then, when you're external process runs, set the tick equal to green or red or whatever other...

Thanks for the reply. I'll take a look at that. I was scouring the internet yesterday and came upon the topic of SQL Agent Tokens which I think...

Sorry, didn't replace [job_id] with [name] like I said:

SELECT [name]

FROM msdb.dbo.sysjobs

WHERE job_id = CONVERT(uniqueidentifier, $(ESCAPE_NONE(JOBID)))

Sounds good.

Yes, you'd be able to do that.

Have you tried looking into the Unpivot component for the data flow? I haven't had much experience with it, but from my experience it should help you with what...

You can look at how the package is made- what components it contains and what transformations are being performed.

If you're going to just do an import or export, it's easier to use the wizard and let it build the package. The wizard builds you an SSIS package,...

The article at http://www.databasejournal.com/features/mssql/article.php/3580216 should help you get started with the import and export wizard.

To schedule it as a job, you will probably do best by changing the...

Hi,

See my post at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=349385. It should help you get through your issue.

Let me know if that helps.

Steve

Thanks for the reply, Frank. If I understand this correctly, this will be exactly what I need to to.

The conditional split component solved the first check where I check...

I saw them but wasn't sure how to utilize them. I'll take a look at the BOL and then try to work something out.

Thanks for the info.

I would suggest taking a look at SQL Server 2005 SP2 as it should have more integration with SharePoint. See this article:

http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx

Good information. Thanks for that. I am still ironing out some of the ways to use SSIS in SQL. I was able to get my packages up...