Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 2,487 total)

  • RE: DTS - Variable length file

    Probably the best method would be to import the file into a staging table with only one field. Then run some SQL to spilt the record up into your destination...

    --------------------
    Colt 45 - the original point and click interface

    February 20, 2003 at 4:48 pm

    #449439

  • RE: SQLBase import error into MS SQL Server using DTS

    Using the ODBC connection that you created, can you query the data in SQLBase and see what fields are returned?

    You might be getting an extra field on either side of...

    --------------------
    Colt 45 - the original point and click interface

    February 20, 2003 at 4:46 pm

    #449438

  • RE: DTS package in a cursor

    Check out

    http://www.sqldts.com/default.aspx?6,101,200,0,1

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

    February 20, 2003 at 4:43 pm

    #449436

  • RE: DTS Run Time

    Bring up the package properties and select the "Logging" tab. Then you can specify a server to log to.

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

    February 20, 2003 at 4:41 pm

    #449435

  • RE: Syntax Error For DTSRUN Command

    Well for starters it's not an SQL statement, it's a CmdExec statement. That's probably the cause of the error.

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

    February 20, 2003 at 4:40 pm

    #449434

  • RE: DTS package in a cursor

    Two things,

    1) It looks like you're using the same filename for each record. Does the file get deleted successfully? Maybe your email process is stopping the file from being deleted...

    --------------------
    Colt 45 - the original point and click interface

    February 19, 2003 at 3:34 pm

    #449313

  • RE: Generic DTS Package

    quote:

    Secondly i want to give user complete independence aboiut defining the FK/PK relationships or integrity checks.

    --------------------
    Colt 45 - the original point and click interface

    February 19, 2003 at 6:03 am

    #449256

  • RE: DTS Run Time

    If you are on SQL 2000, you can turn on Package Logging. Then you can get timings on package and step execution from the msdb database.

    sysdtspackagelog - cotains package execution...

    --------------------
    Colt 45 - the original point and click interface

    February 18, 2003 at 4:42 pm

    #449225

  • RE: Syntax Error For DTSRUN Command

    The message you get sort of points to an error with some SQL being used within the package.

    Can you successfully execute the package via the designer?

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

    February 18, 2003 at 4:39 pm

    #449224

  • RE: Generic DTS Package

    Yes it is possible.

    To get an idea on what you can do with DTS, get the SQL Server Accelerator for BI.

    http://www.microsoft.com/solutions/bi/

    With this tool you define what you want your datawarehouse...

    --------------------
    Colt 45 - the original point and click interface

    February 18, 2003 at 2:15 am

    #449165

  • RE: Email Nightmare

    Have a look at the following discussion and see if it gives you some ideas.

    http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=571&FORUM_ID=23&CAT_ID=2&Topic_Title=CDONTS%20Email%20from%20SQL*Server&Forum_Title=General

    Also check this article to see if you've got things setup correctly,

    http://support.microsoft.com/view/tn.asp?kb=312839

    Thanks

    Phill Carter

    Edited by - phillcart...

    --------------------
    Colt 45 - the original point and click interface

    February 17, 2003 at 11:03 pm

    #449163

  • RE: String Value Validation

    I've always done client side validation. This prevents someone using SQL Injection by entering something like,

    Insert into dbo.CUSTOMER(comments) value '' exec master..xp_executesql 'drop table dbo.customer'--'

    Not to sure what the equivalent...

    --------------------
    Colt 45 - the original point and click interface

    February 17, 2003 at 10:59 pm

    #449162

  • RE: Linked server query error...

    Check out

    http://support.microsoft.com/default.aspx?scid=kb;en-us;306401

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

    February 17, 2003 at 4:14 pm

    #449159

  • RE: Load data with Data Pump Task

    If you select {LF} as the row terminator you'll be able to import all the rows in the file. You'll get an extra column that has the carrige return character...

    --------------------
    Colt 45 - the original point and click interface

    February 17, 2003 at 3:53 pm

    #449155

  • RE: Reporting with Multiple results sets

    Define "reasonably 'pretty' format" what output are you looking for?

    You could put together something in ASP. I believe there is a NextResult method that allows you to process multiple resultsets.

    Thanks

    Phill...

    --------------------
    Colt 45 - the original point and click interface

    February 17, 2003 at 3:42 pm

    #449152

Viewing 15 posts - 2,341 through 2,355 (of 2,487 total)