Viewing 15 posts - 1 through 15 (of 49 total)
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...
February 23, 2009 at 11:07 am
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...
February 23, 2009 at 10:18 am
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. ...
December 4, 2008 at 3:56 pm
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...
December 3, 2008 at 9:58 am
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...
January 22, 2007 at 2:58 pm
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...
November 13, 2006 at 9:54 am
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...
October 3, 2006 at 8:20 am
Nope.. the Page Layout is set correctly in RS at the intersection of the rulers, under Properties, Layout..
Any other places to look?
- Mark
September 15, 2006 at 11:28 am
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...
September 15, 2006 at 9:33 am
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...
July 11, 2006 at 8:14 am
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
June 16, 2006 at 7:42 am
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
June 6, 2006 at 8:04 am
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...
March 24, 2006 at 1:05 pm
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...
March 14, 2006 at 7:30 am
Viewing 15 posts - 1 through 15 (of 49 total)