Isaac
Lifelong Learner
- Local time
- Today, 06:56
- Joined
- Mar 14, 2017
- Messages
- 11,421
I'm going to be setting up a process on a virtual private server running Windows 2019. MS Access, SQL Server Express will be involved.
I'll also be using the free version of SQL Server Data Tools in order to create an SSIS package to load some flat files into SQL Server.
(Actually, I'm still assessing my options there - I might just use T-SQL bulk load operations instead ... but for the sake of this question, I'm evaluating the viability of going the SSIS route for load).
First, my background includes a lot of experience as a developer, but NOT as a dba, although I have limited exposure to some dba activities.
I know that using the above-referenced tools, I'll be able to create a DTSX file and run the package in Visual Studio. However, I'm wanting to know how it can be more automated. If I am using SQL Server Express, I won't be able to have Integration Services or SQL Agent running.......Right? So is there still any way for me to fire off my SSIS package in an automated way? Or is the only solution for someone to open it and hit F5 every time? If that's correct, then this will probably lead to me deciding to use bulk insert (or similar IO) instead.
In fact the more I type this, the more I realize I might as well just use bulk insert rather than utilizing SSIS at all. But I'd like to confirm that I'm correct in stating, using those tools, I'd be able to create an SSIS package....but probably not automate the running of it, at least using anything normal.
Just wanting to triple-check if it sounds like I have said anything incorrectly or have forgotten any possibility or other thoughts, thank you for looking.
I'll also be using the free version of SQL Server Data Tools in order to create an SSIS package to load some flat files into SQL Server.
(Actually, I'm still assessing my options there - I might just use T-SQL bulk load operations instead ... but for the sake of this question, I'm evaluating the viability of going the SSIS route for load).
First, my background includes a lot of experience as a developer, but NOT as a dba, although I have limited exposure to some dba activities.
I know that using the above-referenced tools, I'll be able to create a DTSX file and run the package in Visual Studio. However, I'm wanting to know how it can be more automated. If I am using SQL Server Express, I won't be able to have Integration Services or SQL Agent running.......Right? So is there still any way for me to fire off my SSIS package in an automated way? Or is the only solution for someone to open it and hit F5 every time? If that's correct, then this will probably lead to me deciding to use bulk insert (or similar IO) instead.
In fact the more I type this, the more I realize I might as well just use bulk insert rather than utilizing SSIS at all. But I'd like to confirm that I'm correct in stating, using those tools, I'd be able to create an SSIS package....but probably not automate the running of it, at least using anything normal.
Just wanting to triple-check if it sounds like I have said anything incorrectly or have forgotten any possibility or other thoughts, thank you for looking.
