Create your database sample from a excel file using deltasqltool

Create your database sample from a excel file using deltasqltool
4.7 (93.33%) 3 votes

Hi guys,

 

Did you ever think about how you can have a sample data to start build your ETL in meantime you don’t have access to the database?

Imagine the following scenario,

You’re a Europe(an) database administrator and you have received new requirements to build a new report. You found that the required data is located at China and your connection is actually strictly limited due security restrictions on both countries.

The integration will be something as I illustrate on the below figure.

 

DiagramTransferDataDBs

Continue reading “Create your database sample from a excel file using deltasqltool”

Excel found unreadable content when exporting a SSRS report

Excel found unreadable content when exporting a SSRS report
4.7 (93.33%) 3 votes

Hi guys,

I ran into a strange bug in Visual Studio when I was developing a new report to track the effort of each team member. Noticed that “description” field on the incidents was containing an invalid ASCII symbol,called “VT”. Imagine field “description” as a field available on a random ITIL platform where the users enters the full incident description.

Continue reading “Excel found unreadable content when exporting a SSRS report”