SSIS DB* sorry typo.

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...

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...

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...

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...

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...

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.

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 1 year, 11 months ago by  rocky_498.

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"

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,...

Thank you, Scott!

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

Looks good!

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...

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...

Thanks, Phil. Let me take a peek.

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,...