Forum Replies Created

Viewing 15 posts - 6,556 through 6,570 (of 7,168 total)

  • RE: ForEach Loop with Variable not working

    Do you think it was a dtexec limit? an OS shell limit? other limit?

  • RE: Best way to normalize

    Lamprey13 (4/25/2011)


    I'm not sure what the data represents, but it appears that you'd be better off changing the schema rather than working on the query. Again, without knowing what the...

  • RE: Is SSIS actually useful?

    Good topic...I have agreed and disagreed with points in everyones posts so far. I say use what's secure, what performs well enough to support the goal in mind and allow...

  • RE: File System task

    srilu_bannu (4/22/2011)


    I am sorry for not being clear .

    This what i did:

    1.Right click on the package and clicked variables.

    2.to the left of a package you will see variables

    3.i have...

  • RE: Get username...

    SpectralGhost (4/22/2011)


    I'm not setting up a new system and it is incredibly large, so altering design is not an option at this point.

    I understand the challenge you're facing, but as...

  • RE: Number of devices used

    Another drive-by posting brought to us by Syed.

    Here again, those values are irrelevant unless they're backed by real licensing purchases, That said, they will always return DISABLED and NULL by...

  • RE: How to find the SQL Server's FQDN using t-sql and insert into a field in a record

    Thanks for posting back to the thread...it's good to hear what solutions people are landing on.

    Sounds like you are in good hands but I am just curious and can't help...

  • RE: does physical dll file needed after we have create assembly based on it?

    sturner, you and I are on the same track. The article in my previous post deals with the issue.

  • RE: Is SSIS actually useful?

    I can identify with your frustration. I avoid SSIS unless I truly want to do Transformation work that justifies the overhead, but that bar is moving higher and higher for...

  • RE: Get username...

    SpectralGhost (4/22/2011)


    For security, we use a single SQL account to connect, so users don't have right to the database

    Your choice surrounding database security with respect to your application is the...

  • RE: Number of devices used

    Sumanta Roy (4/20/2011)


    Is there any way to find the number of devices using the SQL server? Can we find what kind of license model(Processor License/Server plus Device CALs/Server plus User...

  • RE: NEED HELP= Monthly SQL database growth calculation script

    Can you please provide:

    1) DDL to create your test tables

    2) DML to create some sample data

    3) The queries you have tried so far

    4) the desired output

    If you do not understand...

  • RE: Need help in TSQL logic

    Can you please provide:

    1) DDL to create your test tables

    2) DML to create test data

    3) The queries you have tried so far

    If you do not understand why I am asking...

  • RE: File System task

    srilu_bannu (4/21/2011)


    Hi all ,

    I have a requirement to save the source files and maintain history of the files.

    I have used File System Task to deliver the file to a directory...

  • RE: Query to find matching databases

    Shamshad Ali (4/21/2011)


    Hi all experts,

    I have to fill a dropdown with all databases which are online and find a table into it. How do I do this? I have to...

Viewing 15 posts - 6,556 through 6,570 (of 7,168 total)