You don't need a script task to export a table in SSIS , chose a dataflow task within SSIS. Make ole db the source and make a flat file...

Do you have anything configured under report properties for available values and default values that might cause this behavior?

LutzM (5/3/2014)

Just wondering: Why is a PK column refernced by more than one column of another table?

There are cases when it...

I am wondering if the projects table can serve as a...

Don't know that you install one, they are created within SQL Server. Start with planning what you expect the size to grow to in the future. For each potential table...

I've never tried a database diagram but it might be useful in this case to visualize the entity relationships.

There may also be triggers in place doing writes somewhere.

You can have two jobs running simultaneously and importing to the different tables. If the data resides on different machines you would need to connect via linked server objects. So...

You can go with the one data warehouse approach. I would employ the use of schemas to denote where the information comes from. Example, china.orders will be the same as...

Do you need to get the week start and end dates, or the week number in the year? Have you considered the use of a calendar table? Keep in mind...

Not sure. I think count returns an integer and the largest number that can return is 2,147,483,647. Do you have some more information on your query that can help?

Extra comma's where? Do you mean there were extra fields in the text file that had empty string values? Else the purpose of the double quotes is to denote any...

Something interesting would be the new challenge of keeping up with the many views that can now be created against a single table. Such as to display one set of...

CASE

WHEN l.GNLFSMID IN (127)

THEN SUM(l.GNLBalanceBase) OVER (PARTITION BY l.GNLCOAID)

ELSE '0'

See if this might help,...

Are the datasets in the reports using stored procedures or is the sql typed in directly? The former will be faster. If they are procedures... are they also slow when...