Forum Replies Created
Viewing 15 posts - 4,846 through 4,860 (of 13,872 total)
-
RE: Setting up 2016
dwilliscp - Wednesday, December 6, 2017 1:37 PM -
RE: Double quote (") issue in the source .csv file in SSIS
rocky_498 - Wednesday, December 6, 2017 1:03 PM -
RE: find out what transaction caused the log file to become full yesterday or day before yesterday
Use DBCC OPENTRAN to look for open transactions.
-
RE: Did anybody have this problem
And here's that query again, for those with standard-width screens 🙂
SELECT
(
SELECT ISNULL(SUM(TOTAL_PAYMENTS), 0)
FROM Orders
WHERE
ST_ID IN ( -
RE: Failed to start project ; Exception deserializing the package "values doesn't fall within the expected range"
Not sure about the error, but this task may work better using xp_Dirtree. Here is an example:
DROP TABLE IF EXISTS #ResultsCREATE TABLE #Results
( -
RE: Are the posted questions getting worse?
Ed Wagner - Tuesday, December 5, 2017 8:21 AMRE: Import JSON api data from http request to SQL server
adamblack - Monday, December 4, 2017 10:46 AMPhil Parkin - Monday, December 4, 2017 10:21 AMRE: Import JSON api data from http request to SQL server
adamblack - Monday, December 4, 2017 10:06 AMRE: SSIS Foreach Loop Not archiving files
Can you paste the code from your script task?
RE: Load Text file data to structured table format
Tsql-561486 - Friday, December 1, 2017 1:07 PMWell done! Out of interest, how...
RE: Flat file connection manager
Got the file, but the reason I asked for a simple package was to avoid errors like this 🙂
RE: Flat file connection manager
Can you post a (simple) sample package which has this problem? I'll have a look if you do.
RE: Redirecting Error Rows using SQL
sadie - Thursday, November 30, 2017 4:07 PMRE: Formatting Data Exported to Excel
FridayNightGiant - Thursday, November 30, 2017 8:51 AMRE: Load Text file data to structured table format
Tsql-561486 - Thursday, November 30, 2017 8:00 AMViewing 15 posts - 4,846 through 4,860 (of 13,872 total)
