Then you will need multiple get-childitem calls and you will either need to append them all to the same CSV OR store it all in a variable (ie in memory)...

For requests 3 and 4, I would say google those.  3 is EASY as that is just a parameter.  4 is pretty easy too as you just need to call...

As an alternate suggestion, you could drop the existing database and then do the restore as then you should have the disk space.  This is the approach I usually take...

I agree with ZZartin, there is no left join in that query... I don't see any joins...

Now, that being said, execution plan is going to be your friend for performance...

I just wanted to add in that I am not a big fan of the "SELECT * INTO" approach to table creation.  It recreates the table, but only the bare...

My guess - you got a bad download.  I would try re-downloading it and give it another shot.  Failing that, I would guess that something is blocking some downloads for...

Your syntax is wrong for SQL Server.  You can't use SELECT in a CREATE TABLE statement.  I recommend you review the documentation from Microsoft on CREATE TABLE syntax (https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver15) and...

• This reply was modified 3 years, 6 months ago by Mr. Brian Gale.

Without seeing your data or table structures, my best guess is one of the following:

1 - your data is unordered - that is you are not putting in an "ORDER...

The error message is telling you EXACTLY what is wrong - the path was not found.

Looking at your code, there are a few things that I am a little confused...

Personally, I think that sounds like a lot to work on, but I am hoping that you do get some interest in it.  One concern an end user may have...

Personally, I wouldn't put the GPX file on there.  I have never looked at those, but I have a feeling that it contains GPS data in there.  People could use...

I agree with TangoVictor on this one - I would be looking to have the business sanitize the data before allowing it to be handled by SSIS.  one user puts...

What I would strongly recommend to get good results on this forum is:

1 - post DDL in a consumable format such as:

CREATE TABLE sample (JSONData NVARCHAR(MAX))

2 -...

I agree with Homebrew01 here - I would do this in a table.  That way the logic is EASY to update in the event your fiscal year changes.  You MAY...

To add to what Jeff said - I got my DBA (Jr. DBA at the time) job with no degree or any certs.  I got some certs after getting the...