Archive for the 'SSIS/DTS' Category

I was recently dealing with importing a DBISAM (Btrieve) database to SQL Server, which had separate date and time columns where I wanted to import a DateTime.  Using the ODBC driver and a DataReader data source, it was returning the date as the DT_DBTIMESTAMP type and the time as a DT_I8 long integer. I tried [...]

If you want to add a constant GUID to a table during a DTS transformation, it’s a little tricky.  Here’s the solution. Use the Derived Column transformation in order to add a new column.  For the formula, use the GUID surrounded by double quotes.  The trick is that you MUST include the curly braces, like [...]