Forum Replies Created

Viewing 15 posts - 1 through 15 (of 49 total)

  • RE: How to modify filename SSIS FTP

    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...

  • RE: SSIS Security Help

    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...

  • RE: hi

    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..)...

  • RE: Setting Package protection level

    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. ...

  • RE: Scheduling SSIS Packages

    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...

  • RE: Using variable as a comuln name in a select

    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...

  • RE: OpenRowset Excel problem

    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...

  • RE: Ridiculously STRANGE query - help please?

    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...

  • RE: Printing issues.. Custom page size??

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

    Any other places to look?

    - Mark

  • RE: Printing issues.. Custom page size??

    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...

  • RE: DTS Error while executing

    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...

  • RE: Temp Tables not clearing

    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

  • RE: Migrating TempDB

    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

  • RE: Automated DTS Package Job

    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...

  • RE: Diagrams

    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...

Viewing 15 posts - 1 through 15 (of 49 total)