Thanks for the response. I've been trying to confirm that the package was actually using the connection string from the XML config file. It now appears to be...

Hello,

I have read the article and the discussion with interest. I've tried to build and run a package that moves a file on our company's network to a test...

Howard, thanks again. I got the FTP connection manager to read the user name and password from my config table via 'Package Conguration'. I have verified that both...

Howard, thanks again for the tip. I'm using an Execute SQL task and using it with a table I created on the SQL server.

I've successfully created an expression that...

Thanks for the reply, Howard! When I get a chance I'll take a look at what you wrote in detail.

Out of curiousity, what are you going to do with hard tables in a SELECT INTO when it's ran concurrently? This technique is almost explicitly used for #tmp tables because...

Thanks, Sean. I think dynamic sql would be a big headache. I'll just make do with the way it is.

Thanks Welsh Corgi, also.

Welsh Corgi, thanks for the suggestion. I am reluctant to change to the insert-into method because I think it will take longer overall.

Sean, thanks for the reply. I...

I'm using select-into rather than insert-into because I don't have a good idea what the table structure is. The select statement is huge, and it is much easier to...

thanks, GSquared, it now works perfectly.

I appreciate the tip.

🙂

hi GSquared,

I tried your suggestion. unfortunately, i'm still not getting the parameter values back as intended.

thanks,

Hi Lynn,

I changed the call to be:

exec sp_test_Called

@vEffectiveBegin=@vEffectiveBegin_1 output,

@vEffectiveEnd=@vEffectiveEnd_1 output,

@vDate1=@vOur_Date_1,

@vDate2=@vOur_Date_2

this makes my calling stored proc look like this:

alter proc [dbo].[sp_Test_Callee]

as

declare @vEffectiveBegin datetime

declare @vEffectiveEnd datetime

declare @vEffectiveBegin_1 datetime

declare @vEffectiveEnd_1 datetime

declare @vOur_Date_1 datetime

declare...

Hi Lynn,

the Backup To dialogue I'm referring to is seen here:

(I used the Master database for the image. The Master db is fine.)

For a few databases, I see...

Hi,

Here's another piece of info. For the database that I'm most concerned with, I have tried these statements:

use [database_name]

go

select * from sys.database_files

the physical names for the database and the...

Luke,

thanks for the tip. I'm going to try to follow your advice. Once this database is in production, I won't be able to shrink and resize the log...