I am running a flatfile Data task into an OLEDB(SQL Sever) destination. The data comes in as such....
Youll see they come in 3's in no particular order...All I need is the ID and currency rows(amount). But since Im doing it in SSIS If I can load these into 3 seperate columns in some kind of order then I can identify the currency column and just select that column in my next task. But if I can create a table in sql that just includes the ID and amount(currency column) and have 1 row for each id and each amount that would be best. I hope this makes sense..The best outcome I could get is the following..
A table with this from the above data would be ideal
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video.
If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…