Change data type of variable in Execute SQL Task

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80325 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Phil Parkin SSC Guru Points: 246988 More actions · Answer 2

Are they both in YYYYMMDD format?

There is no such thing as an 'Execute SQL Script Task component'. I think you mean an ExecuteSQL task, is that correct?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

christi1711 SSC-Addicted Points: 441 More actions · Answer 3

SSC-Addicted

Points: 441

July 3, 2021 at 8:14 pm

Hi, Phil

Yes, it's correct!

Phil Parkin SSC Guru Points: 246988 More actions · Answer 4

I imagine you have a reason for setting the variables as string in the package, but if not, why not just make them INTs?

Alternatively, create two new INT variables and use an Expression to convert the string variables to INTs, like this:

2021-07-04_12-28-19

Once you have the two INTs created, just adjust your ExecSQL task to use them rather than the string variables.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

frederico_fonseca SSCoach Points: 16167 More actions · Answer 5

no need for further variables.

just do the conversion in sql

delete from T1 where date_cr between convert(int, ?) and convert(int, ?)

Jeffrey Williams SSC Guru Points: 90305 More actions · Answer 6

frederico_fonseca wrote:

no need for further variables.
just do the conversion in sql
delete from T1 where date_cr between convert(int, ?) and convert(int, ?)

Or - just let SQL implicitly convert them to integer. But - I also wonder why they are set to string in the first place.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

christi1711 SSC-Addicted Points: 441 More actions · Answer 7

Hi Jeffrey,

I used string because there is some C# code and manipulation with source data. That's why I decided to left this format.

The main problem that I have not 20210707 string format, but such kind of string format - 2021-07-07...