It appears you've created a formula that would be used with an expression, but you are trying to use that directly in the Execute SQL Task as if you were...

Thanks Igor for the interesting question.

This is definitely good to know, since it doesn't seem to be documented anywhere. :crazy:

You can do this one of two ways:

1. Use a parameter to pass the value of your variable into your query.

2. Use an expression in your Execute SQL task...

If I understand what you are trying to do correctly, you can use a case statement to add the additional restriction of being within 5 days of the appointment:

SELECT

fa.new_sitename...

Haha, you beat me to it John Mitchell-245523!

Would this work?

SELECT

Row_ID, Serial_Table.Serial_Number + Sequence.Digit

FROM

Serial_Table

JOIN

(

SELECT

DIGIT

FROM

(VALUES (0), (1),(2),(3),(4),(5),(6),(7),(8),(9), (10)) Numbers(digit)

) Sequence

ON

Sequence.Digit <= Serial_Table.End_Serial_Number - Serial_table.Serial_Number

I am not very familiar with the instant client. I know that it does not include the TNSNAMES.ORA file used to configure the SID used to connect to your...

Oh, I should also probably mention that your Oracle client needs to be configured for the Oracle server you are trying to connect to.

https://docs.oracle.com/cd/B16276_01/doc/server.102/b14196/network005.htm

The SID that you provide in the...

Ugh, well this is where things get a little weird.

In theory, you should be able to write a 64-bit package that uses the 64-bit client and everything works...

To use a domain account to connect to servers, you'll need to set your connections up with the option 'use windows authentication'. You will then need to run the...

Well, I learned something today. :angry: :hehe:

Is it possible to run Powershell scripts from within SQL Server though without enabling xp_CMDShell?

I generally use a ForEach Loop for file detection for the simplicity, but there is at least one situation where it may not be appropriate. The ForEach Loop will...

I don't think you can use a SQL Query task to get the table names.

I believe you will need to add a Data Flow, and in the data flow use...

You could probably do this in your script task by opening the file and counting the rows.

It'd probably be easier though to add a data flow after your script to...