Forum Replies Created

Viewing 15 posts - 736 through 750 (of 13,460 total)

  • RE: SSIS Script Task if Variable RecordCount >0 Fail Package

    Welsh Corgi (12/23/2016)

    Lowell (12/21/2016)

    Dts.Events.FireError is what you want.

    is your account used by a team of users, and not an individual?

    Trivially adapted from part of an answer I posted for...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 23, 2016 at 4:47 am

    #1919498

  • RE: Are the posted questions getting worse?

    djj (12/22/2016)

    Has anyone had their gallbladder removed? What was the recovery like? Can you go back to work in three days.

    If you haven't guessed I need mine out.

    I...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 22, 2016 at 12:20 pm

    #1919413

  • RE: Why is the email not coming to me from DB

    look to see what database mail has to say about the specific message; it could be that a firewall issue prevents connections, or you misspelled a password or something:

    SELECT top...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 21, 2016 at 4:06 pm

    #1919249

  • RE: SSIS Script Task if Variable RecordCount >0 Fail Package

    Dts.Events.FireError is what you want.

    is your account used by a team of users, and not an individual?

    Trivially adapted from part of an answer I posted for you yesterday @4:40pm(less...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 21, 2016 at 2:07 pm

    #1919236

  • RE: Email Formatted HTML Table with T-SQL

    thakur.bhagat24 (12/20/2016)

    In previous example is very useful

    But I have one new requirement of order by color what we get using below case.

    CASE WHEN (ROW_NUMBER() OVER (ORDER BY [SpecialOfferID]))%2...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 21, 2016 at 6:24 am

    #1919126

  • RE: IF Exist Delete file and copy a Template File VB.NET Script Task

    here's a C# code example, change directory to file, and

    try

    {

    string FileName = (string)Dts.Variables["BHCS_InPatient_File"].Value;

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 2:40 pm

    #1919041

  • RE: Copy File in SSIS using VB.NET

    Welsh Corgi (12/20/2016)

    There is an issue with the last line of code.Any ideas?

    what is the issue? you've been around long enough to know exact errors and a description of the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 12:11 pm

    #1919001

  • RE: IF Exist Delete file and copy a Template File VB.NET Script Task

    Welsh Corgi (12/20/2016)

    What am I missing?

    also a try catch to capture any errors raised you did not expect.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 12:09 pm

    #1918999

  • RE: SSIS defaults to C# on a script task -- Need VB.NET

    http://www.sqlservercentral.com/Forums/Topic942127-364-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 10:45 am

    #1918980

  • RE: Extended Events & sys.dm_exec_connections

    local_net_address is the server itself, don't you mean the client_net_address instead?

    --EDIT--

    anyway, I don't think IP address for the connector is exposed anywhere in Extended Events. you might get away with...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 10:18 am

    #1918975

  • RE: Performance Finger pointing: suggestions on next steps.

    right, that of course was one of the places i've been looking, as well as the classic slowest running queries.

    this package is extremely simple, it's pure truncate and reload,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 9:57 am

    #1918972

  • RE: Warning1[rsInvalidColor] The value of the BackgroundColor property for the page ‘Page’ is “Light Green”, which is not a valid BackgroundColor.

    yrstruly (12/20/2016)

    Would you please follow as i have shown vi the link i provided.

    I saw the error message; that was what made it clear that the alias for the color...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 9:17 am

    #1918951

  • RE: Warning1[rsInvalidColor] The value of the BackgroundColor property for the page ‘Page’ is “Light Green”, which is not a valid BackgroundColor.

    weird; via the GUI, i am able to set the background on either the page or the body with no problem, for example.

    i don't see the color until it's rendered,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 9:04 am

    #1918946

  • RE: Warning1[rsInvalidColor] The value of the BackgroundColor property for the page ‘Page’ is “Light Green”, which is not a valid BackgroundColor.

    color Aliases do not have a spaces in them. LightGreen would be correct.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 8:56 am

    #1918942

  • RE: Parallel Processing using C# in a SSIS 2012 Execute Script Task for calling multiple DTSX packages stored at DTS or File System

    anupam.jha (12/20/2016)

    Hi Gents,

    I have landed into a scenario where we have around 60 to 70 SSIS packages that would be loading data into the datawarehouse.

    Most of the individual SSIS packages...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 20, 2016 at 8:30 am

    #1918933

Viewing 15 posts - 736 through 750 (of 13,460 total)