Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Error With BCP

    Ok, here is the weird thing. This statement works:

    SET @bcpCommand = 'bcp "SELECT * FROM (database)..(table)" queryout "E:\CMS\color.txt" -U (user) -P (pw) -c'

    This statement doesn't:

    SET @bcpCommand = 'bcp "SELECT * FROM (database)..(different...

  • RE: Error With BCP

    Ok, thanks, I'll check with my DBA.

  • RE: Error With BCP

    With your permissions problem, are you referring to the ability to create files on the drive, ability to access tables, or something entirely different? Thanks for your suggestions.

  • RE: Error using BCP

    I had added the -t and -r in there while I was trying to get it to work. It still errors out without them. I also tried placing the username...

  • RE: Passing a Global Variable Into a SQL Script

    Krystian,

    You can't assign parameters there, because technically they aren't parameters. Parameters are passed into stored procedures, and that is just a query. If you place that query in a stored...

  • RE: Executing SQL in ActiveX Script Task

    Edwin,

    I don't think you can do what you want to do. I was looking at doing something similar this week. I looked all over the internet, but I couldn't find...

Viewing 6 posts - 1 through 6 (of 6 total)