The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)...

I'm using SSIS to load a file from the network. In this case I don't know the filename ahead of time and was just wondering what methods people use.

I'm not...

Thanks Phil, yeah that's the default value when creating the container.

I was asking outside of the FELC or Script Task is there a technique people use.

just add the following bold line.

WHERE [NAME] != 'master'

AND state_desc = 'ONLINE'

So open the file and just close it does it ask "Do want to save changes"?

It shouldn't because nothing would have changed.

So when you say save it, do you mean...

OK thanks Phil, that makes sense I don't need further examples. The XML is pretty straight forward and generally only contains one or 2 OTime elements. It's xml we generate...

Thank You Phil!

The key I was missing is using the i as the alias, not the x.i (from my example) or the x not r.x from your example.

That is what...

What about .Net? Could you do something in a script component source maybe?

https://docs.microsoft.com/en-us/dotnet/api/system.xml.serialization.xmlserializer.deserialize?view=netcore-3.1

https://docs.microsoft.com/en-us/dotnet/framework/wcf/feature-details/importing-schema-to-generate-classes

I agree with Chris on this as well, just trying to give an option that fits with your current pattern.

One way you could do this would be to use a recordset destination then follow the data flow with a for each ADO.Net recordset loop. Then use an exec sql...

Yeah i like this approach, i never used the dts.events, going to keep this one in mind for future stuff.

I just did a project and needed the info to be...

As Phil suggested you should have try/catch/finally blocks in your code and be logging these operations to maybe a text file.

add a log file to your process will save you...

I assume you're just referring to visual appearance of the package. There is a Format menu option, to help you with some of that.

If you select a group of components...

I just typed this in and it works fine, what error you getting?

(DT_WSTR,255)("e C:\\Users\\as1981\\Downloads\\stackoverflow\\0302020 StackOverflow\\") + (DT_WSTR,255)( @[User::Filename])

here is the result when i hit Evaluate Expression:

e C:\Users\as1981\Downloads\stackoverflow\0302020...

did you configure your connections after deploying the package or are you hitting your dev connections?

account have access to those tables?