Create a variable, Fname (or whatever), that is scoped to the Package. Set the property, EvaluateAsExpression to True.

Set the Expression to be (and I may need help here but there...

I don't know if you've gotten your problem solved yet or not, but just so you have something to try - consider the following:

Have you looked into the ProtectionLevel of...

I'm not sure if you're running this in BIDS or as Deployed.. but either way, I believe that if you enable Package Configurations (right-click on workspace, click on Package Configurations..)...

Check out a similar post: http://www.sqlservercentral.com/Forums/Topic600005-148-1.aspx#bm613484

I haven't done the deployment into SQL Server (using filesystem instead) but sounds like you could benefit from using a Proxy Account & Credentials. ...

Not sure if you've resolved this or not but I've had the same issue and have found the following from various sources:

The default setting for the package ProtectionLevel is EncryptSensitiveWithUserKey...

AJ,

If you want some experience in using Dynamic SQL, take a look at some code that was posted here a while back by aclaver1 on 12-FEB-2004.  I've adapted a version...

If you want to delete an xls file before you start, try this:  (You'll need to set your variable accordingly.)  I use this code snippet in a proc that runs...

This is not a solution as much as it is a comment on strange behavior.. (SQL, not mine).

Try scripting the table that was created by your SELECT INTO.. and then...

Nope.. the Page Layout is set correctly in RS at the intersection of the rulers, under Properties, Layout..

Any other places to look?

- Mark

Yeah.. that's not the issue I'm describing.  I have a RS report that is defined as 8.5" x 11.0 ".  The preview of the report looks fine, however when I...

I'm trying to go from memory here, and I don't have any information on your specific error message BUT, generally speaking IF you can run the DTS manually and it...

This works fine for me on SQL 2000 sp3a... everytime:

IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects WHERE id = object_id(N'tempdb.dbo.#tbl') )

 DROP TABLE #tbl

CREATE TABLE #tbl (....)

hth...

Mark

Try running this after you issue your ALTER statement.. and see where SQL thinks TempDB is..

use

tempdb

go

sp_helpfile

go

hope this helps...

Mark

Several issues here.. and for others who may have the same problem, here's my two cents..

IF you're going to have a DTS package that copies a text file to some...

Try running just the SELECT portion of the script.  Do you get any rows returned?  You're going to have to troubleshoot this one step at a time.  The script always...