I have not used a .dtsConfig file. However, another alternative is to store the SSIS package config data in a SQL table. By default BIDS uses a table...

One way we do this is create a SQL Agent job that calls the SSIS package. The the client application executes "sp_start_job". The client would require execute permission...

The -1 is subtracting the hours and minutes portion of the @adt_start_date, so you're basically left with that date at midnight. The SQL datetime datatype can be represented as...

I have several SSIS packages that run queries against our AS400 daily. I have set up a linked server using a Data Source that connects using the iSeries ODBC...

Yes, my feeling is like Phil's - why are you not using the data flow toolbox components, like flat file source, or data conversion, etc? Unless I'm missing...

If you are using the SQL Agent you can also use VBScript:

==========================================================

Option Explicit

on error resume next

Dim oFSO

Dim sDirectoryPath

Dim oFolder

Dim oFileCollection

Dim oFile

Dim iDaysOld

'Customize values here to fit your needs

iDaysOld = 5

Set...

Given the nature of the modules you describe, you may want to look into the open source DotNetNuke framework for ideas.

http://www.dotnetnuke.com/

You can use a SQL Agent job to execute the SSIS package. If you can't schedule it, then your developers would need to be able to execute sp_start_job.

I'm pretty sure you could accomplish this with the Data Flow Script component. You would have VB.Net at your disposal to interpret or manipulate the date string and...

You may want to look into a database called "Cache" from Intersystems. We have a business application built upon it. It works very well within the confines of...

The two at he top of my list are more Tech-speak than Micro-speak:

In IT we leverage something; the rest of the world uses something.

In IT we have knowledge transfer; the...

We use a Content Management system called ApplicationXtender to manage electronic documents. In our case, well over half of our documents come from external sources and the paper must...

Another thing you will notice is that you cannot run Standard Reports from Management Studio on a level 8.0 database.

I use a client called SecureFx

http://www.vandyke.com/products/securefx/

I have it installed on a server. It has a command line feature that I use to invoke it via a SQL Agent Scheduled...

Yes, I see... I've been digging into BOL; looks like there is quite a bit more involved; encrytion keys, etc.

I was hoping for a quick easy answer but I guess...