questionto42's user avatar
questionto42's user avatar
questionto42's user avatar
questionto42
  • Member for 3 years, 9 months
  • Last seen this week
4 votes
3 answers
1k views

Integer number in the 700000s as the days from year 1: how can this be cast in tsql to a date and back if the oldest datetime date is 1753-01-01?

1 vote
1 answer
16k views

How do I represent foreign key in an Extended ER Model in Chen notation?

1 vote
2 answers
77 views

DFT drops connection and its temporary table after leaving any DFT item, tested with two Script Components. How do I keep the temp table alive?

0 votes
0 answers
6 views

The debugger only stops at the breakpoints of the first Script Component. How do I debug more than one Script Component in an SSIS Data Flow Task?

0 votes
1 answer
16 views

SSIS project window turns white right at the beginning of debugging, status "Running", tricky to get the project back. How do I avoid this crash?

0 votes
0 answers
36 views

TSQL query for metadata statistics like granularity, number of rows, indexes, keys, like a broadened MySQL INFORMATION_SCHEMA.STATISTICS, but for TSQL

0 votes
1 answer
32 views

odbc--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]A collation conflict ... in the UNION ALL operator ... cannot be resolved. (#451)

0 votes
0 answers
27 views

Can I redirect rows on error in SSIS if the error happens within an "if condition", not while writing the column value?

0 votes
2 answers
64 views

How do I create and fill a temporary table with incoming data from a Data Source item without leaving the SSIS Data Flow Task C# Script Component?

-1 votes
2 answers
87 views

Why should you always write "varchar" with the length in brackets behind it? Often, you get the right outcome without doing so

-1 votes
1 answer
225 views

In MySQL query, VARCHAR(100) gets output as "[partnumber]" although in a query with more columns, it is still shown as 'p-12345'