Testing the connection, we find that we are ready to go. The “Connection Manager” dialogue box is now brought up and we configure this box as shown above. The “Configure OLE DB Connection Manager” dialogue box is brought up. We begin by right clicking in the “Connection Manager” box and selecting a “New OLE DB Connection” (see above). Our first task is to create a data connection to our SQLShackFinancial database. We find ourselves on our Integration Services project workspace (see above). We select an Integration Services project and give our project a name. Opening Visual Studio we begin by creating a new Integration Services project.
The astute reader will note that the csv file name contains the date and time on which the file was created. Our end goal is to obtain the following output: We shall utilize data from the FASB table (see below). We are going to construct THIS SOLUTION in today’s get together.Īs our point of departure, we shall once again utilize our ‘SQLShackFinancial” database. Being a strong advocate of using the SSIS toolbox, I experimented with an alternative solution.
The gentleman wanted a SSIS script that would permit him to extract data from a SQL Server database table and place it in a CSV file with a dynamically allocated name. His issue was quite interesting and I decided to share it with you. Late last month I received an email from one of the attendees. A few months back, I presented a paper at SQL Saturday 327 in Johannesburg, South Africa.
0 kommentar(er)
