I am using SSIS2017 and part of what I am doing involves running several (30ish) SQL scripts to be output into flat files into the same folder. My question is, to do this do I have to create 30 New Fi...

I am trying to have upload a CSV file to my SQL Server via SSIS. Previously- like a few months ago- I was able to click 'New' on the destination editor to create a generic table based on the imported ...

I have an SSIS project on VS2017 and in it, I have a connections manager. I also have connection strings to files on the server. I am in the middle of the migration process, so I have to replace the p...

I AM using Oracle datasource in my ETL package which uses SQL command as data Access mode. Unfortunately i AM getting error Cannot convert from SQL type 93 to C type 8 I know that query used in Orac...