Forum Replies Created

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

  • Reply To: SQL agent help

    SSIS DB* sorry typo.

  • Reply To: SQL agent help

    The package was completed successfully. I checked through the SSIDB category, and it shows run and finished fine. However, the SQL Agent Job keeps running and never stops.

    First, I used...

  • Reply To: SQL Pivot query help

    Thank you, Ken and Phil. This is exactly what I am looking for. I ran it to my real data and it works perfectly.

    Thank you, SSC. I will check out...

  • Reply To: Loop query help

    Thanks, Drew for your reply. Did you bother to read my latest post? and did you bother to run the query that I provided?

    IF yes, then my question was in...

  • Reply To: Loop query help

    I want to say thank you very much, everyone. After I carefully reviewed our data and created a sample data. It looks like I need "gra" number based on the...

  • Reply To: Loop query help

    Thanks for your reply.

    My question was, I want to Loop through the whole table, If we met the criteria listed above then 0 else Previous "GRA" value +1 until we...

  • Reply To: Parse SQL data

    Hi Steve,

    It works for the sample data. I am sure it will work on the original data as well. I marked this question as answered. I appreciate your help.

     

     

  • Reply To: SQL Duplicate remove Query

    Here is the SQL script, if someone is looking for a solution.

    select top 1 t.*
    From test_dup src
    join test_dup t on src.f_name = t.l_name
    and...

    • This reply was modified 2 years, 5 months ago by  rocky_498.
  • Reply To: SQL Query Help

    Hi, ratbak,

    Thanks for your help. It worked.

     SELECT d.id,d.fullName,d.city,products.value
    FROM ##Data d
    OUTER APPLY string_split(product_descr,';') products

    "Answered"

  • Reply To: PowerShell script help

    Hi Jeff,

    By chance, do you have an example that I can take a look at in the script task calling the .exe file and pass and return the variable value?

    Thanks,...

  • Reply To: SQL Query Data parsing help

    Thank you, Scott!

    I really appreciate your time to help me and write the query.

    Looks good!

  • Reply To: Powershell script multiple output into SSIS variables

    Thanks for your reply. The PowerShell script is calling a third party .exe file and getting username and PW. I will give a try using C#. However, my biggest concern...

  • Reply To: Powershell script multiple output into SSIS variables

    Thanks for your reply. Yes, I am calling PowerShell script from SSIS (Execute Process task).

    I have a couple of options that I can take.

    1. Combine two outputs in one Output...
  • Reply To: REST API through SSIS

    Thanks, Phil. Let me take a peek.

  • Reply To: SQL query error help

    Hi ratbak, thanks for your advice, and it works. However, it works if its a truncation error. How can I capture if my source is varchar and destination is numeric,...

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