How to Use SSIS for Combining Date & Time
Microsoft SSIS provides database administrators with the ability to set up packages that run on the server at a specified time. Each package contains steps where you create the SQL code for the database processes. You use the SQL code that combines two columns to combine a date and a time column into one statement. The "+" character combines columns in SQL coding.
Other People Are Reading
Instructions
-
-
1
Open the SQL Server Management Studio software on your database server or a computer that has access to the database. Log in to your database server.
-
2
Right-click the SSIS package you want to edit and select "Modify." Double-click the step you want to edit or click "New" to create a new step.
-
-
3
Type the SQL query to combine the date and time. For instance, combine the "mydate" column and the "mytime" column from the "schedule" table into one:
select mydate + ' ' + mytime from schedule
-
4
Click the "Save" button to save the changes. Right-click the package and click "Run" to view the results and run the new package changes.
-
1
