sp_help_revlogin will not copy any server roles assigned to the logins. That will be an additional step.

Also, just a side note, because I ran into this.... the default database...

Another culprit may be your antivirus software. In our environment, we use McAfee and we have to make an AV exception on the SQL servers that use Database Mail...

If I were doing this, I would modify the Currency table to include [ExchangeStartDate] and [ExchangeEndDate] fields. Then I would use a range in the join clause of the...

I have a couple of situations where I need to invoke a process on another server, either directly or by kicking off an "unscheduled" Scheduled Task on another server. ...

I do something similar to poll all of my DB servers:

1) Set up a SQL Task and populate a recordset user variable with server instances and database names

2) Set up...

When you place the Flat File Destination component into your Data Flow, you can create a New flat file connection manager. In your case, once the output connection is...

I haven't done it - but this video by Brian Knight "Loading Binary Files into SQL Server Using SSIS

" looks like a good place to start http://www.sqlshare.com/Media.aspx?vid=62

See this article by Jeff Moden about using the "tally table" approach for splitting delimited strings. First time I used it, it took some time to wrap my head...

You don't necessarily have to execute the package. In the Data Reader Source component, you will note that you have nothing in the Column Mapping tab until it has...

It looks like a you could use a Data Flow task to accomplish this. You should store your login info in a Package configuration and set up your connection...

Why do you need an alpha component in your key? Does each different alpha prefix need to begin incrementing at 1?

That is not related to the structure of the file; it is related to how your windows client is set up. Excel is set as the default application to...

I use the iSeries ODBC driver provided by IBM. Nothing fancy in the ODBC data source set up. Just the IP address, login info, and default db -...

We run a few dozen daily production SSIS jobs. I have my all of my package configs stored in SQL server in a single database. We have implemented...

It is an incremental update. Thanks for the reply.