The databases have some frequent schema changes such as adding a new schema, or modifying a stored procedure, function or trigger. I forgot to mention the databases also use...

• This reply was modified 6 years, 3 months ago by Phil Parkin.
• This reply was modified 6 years, 3 months ago by Phil Parkin.

Step 1. Use table aliases and consistent query formatting. This is the same query, but notice how much easier it is to begin to see what is happening.

            
October 24, 2019 at 7:46 pm
            
#3691756

            
            
                                                
        

Is SSIS able to handle multiple databases in a package?

No problem.

Is SSIS able to handle dynamic schema changes (such as creating a SQL Agent Job on a schedule and running...

There are two rows in your table, yet you are trying to assign single values to scalar variables by selecting from that table. You cannot condense multiple values from your...

Great start. Based on the sample data, what would your desired results look like?

Duplicate post, answers here, please: https://www.sqlservercentral.com/forums/topic/xabse-convert-varchar-to-numeric

You're in a SQL Server forum, not XBase. There may be people here who can help you, but you may be better off finding a forum dedicated to XBase.

'16:00' is not a valid numeric value, so you cannot do this. What are you trying to do?

Are you going to provide DDL & sample data for this?

Thanks, Phil.  I really appreciate your feedback on these types of things.

As a bit of a side bar, how do you like that new Azure ETL tool?  Does it...

Hi Jeff, I'm still fairly new to Azure (six months and counting ... slowly!) and have been spending a lot of time on the DevOps side rather than doing 'proper'...

Azure Blob Source does not supports multiple-character delimiter.

Nit-picking a little, but the delimiter is only a single comma. The double quotes are text qualifiers.

As it's coming out of a text file, it has no...

try
{
OneLineOfCode;
try
{
AnotherLineOfCode;
try
{
ThirdLineOfCode;
}
catch(Exception ex) {}
}
catch(Exception ex) {}
}
catch(Exception ex) {}

This code was "generated by a tool" 🙂

If you can live with the quotes on the column names, it would be easy enough to use derived columns to remove the quotes from the data itself.