Forum Replies Created

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

  • RE: Export Fixed Width

    Jeff Moden (2/26/2015)

    elee1969 (2/26/2015)

    Is using Ragged Right adding another column?

    What's preventing you from trying it to see?

    Hi Jeff, I am using it. Maybe i worded it wrong. I am using...

    February 26, 2015 at 5:23 pm

    #1780438

  • RE: Removing commas

    krypto69 (2/5/2015)

    Hi,

    I have a simple statement where I am trying to remove all commas that may be in the xn_workordeld column.

    SELECT

    xn_workordeld = case replace(xn_workordeld, ',', '') as "WORKORDER...

    February 5, 2015 at 2:05 pm

    #1775880

  • RE: Issue with using Excel in SSIS

    NSB (2/5/2015)

    Thank you for your reply. I've one more questions. I've install the driver in the server where SQL 2012 "server version" is installed or at client system?...

    February 5, 2015 at 12:48 pm

    #1775857

  • RE: Issue with using Excel in SSIS

    Your server needs this driver installed to read excel file.

    http://www.microsoft.com/en-us/download/details.aspx?id=23734

    February 5, 2015 at 11:23 am

    #1775820

  • RE: Execute task base on time

    g.britton (11/13/2014)

    Add expressions to each task that disable the tasks based on the time

    So i would set the property in Expression to 'Disable' it seems. What would i set the...

    November 13, 2014 at 2:29 pm

    #1758405

  • RE: Formattting in Expression Builder

    It looks like i will have to use a 'Script Task' to send a html email. How do i call a variable within the body of the message? for...

    October 29, 2014 at 12:27 pm

    #1755617

  • RE: Sql Help

    mickyT (10/23/2014)

    Sorry this is a bit of a "It Depends" answer. If you are only going to have up to eight courses then the following will do what you...

    October 24, 2014 at 7:48 am

    #1754665

  • RE: Sending multiple emails

    Evil Kraig F (10/9/2014)

    Short answer: Drop off the email and the name into an ADO Recordset object from a dataflow (feed your select statement into a recordset target).

    Use that object...

    October 9, 2014 at 6:28 pm

    #1751477

  • RE: Mapped Network Share

    its not a local drive.

    What i am trying to do is ssis package creates 3 files on Server A. Then have the 3 files places on Server B because server...

    April 29, 2014 at 12:11 pm

    #1709589

  • RE: Mapped Network Share

    Can't get this to work. I used UNC path \\Server\E$\filepath

    I get error can not find path.

    April 29, 2014 at 10:47 am

    #1709564

  • RE: Mapped Network Share

    Phil Parkin (4/25/2014)

    elee1969 (4/24/2014)

    Hello - I am trying to find out what is the best way to have my ssis package export data to flat file on a mapped network...

    April 28, 2014 at 10:46 am

    #1709231

  • RE: Multiple Flat files

    aaron.reese (3/24/2014)

    If the files have an identical structure and it is only the target name that changes then yes, otherwise you might as well have four DFTs (plus DFTs can...

    March 24, 2014 at 8:51 am

    #1699563

  • RE: Multiple Flat files

    Phil Parkin (3/21/2014)

    aaron.reese (3/21/2014)

    Depending on how strict your regression testing is, you might be better off with four separate packages and a master package that calls the four child packages....

    March 21, 2014 at 11:33 am

    #1699204

  • RE: Multiple Flat files

    Phil Parkin (3/20/2014)

    elee1969 (3/20/2014)

    Hello Gurus - I am building a package that has to output 4 flat files. Each flat file uses different tables. What is the best route to...

    March 20, 2014 at 12:48 pm

    #1698850

  • RE: Newbie With Issue

    Jeff Moden (3/18/2014)

    elee1969 (3/18/2014)

    I was able to resolve issue.

    Thanks.

    What did you do to resolve it?

    Change the protectlevel to DoNotSave and created the config file to store the password.

    March 18, 2014 at 2:54 pm

    #1698199

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