Forum Replies Created
Viewing 15 posts - 136 through 150 (of 375 total)
-
Reply To: incremental load
Phil Parkin wrote:How many tables are updated during this process?
Does each table have date created / date modified columns?
Is the incoming data purely inserts, or inserts + updates, or inserts +...
-
Reply To: SSIS error
Jeffrey Williams wrote:Just curious - but you stated you are using SSIS, but here you are using a stored procedure to execute a BULK INSERT?
I have to ask why you decided...
-
Reply To: SSIS error
Ed B wrote:Does this work?
'INSERT INTO DBO.DataTable
SELECT *, NULL, ''N'' AS PROCESSED_FLAG
FROM #TEMP_TABLE'it worked! thank you so much!
-
Reply To: SSIS error
Ed B wrote:I assume the source file does not contain a processed_flag or processed_date column. I just ran a quick bulk insert test and when I added an extra column to...
-
Reply To: SSIS error
MarkP wrote:Next step on the debug root now we've sorted the "is it plugged in" equivalent.
Can you swap the exec for print so that you can see exactly what is...
-
Reply To: SSIS error
MarkP wrote:I'd check your variables. No sign of @FILEPATH being declared or populated anywhere in that.
What does the execute statement of the stored procedure that you are issuing look like?
[quote-1...
-
Reply To: SSIS error
MarkP wrote:I'd check your variables. No sign of @FILEPATH being declared or populated anywhere in that.
What does the execute statement of the stored procedure that you are issuing look like?
it...
-
Reply To: SSIS error
frederico_fonseca wrote:error is very clear - your bulk insert is failing because of data conversion between input (your file) and the output (#TEMP_TABLE).
it has Nothing to do with that flag...
-
Reply To: SSIS error
Jeff Moden wrote:Does you code actually look like what you posted? I ask because there is no space between the terms "SET" and "Processed_Flag" and there needs to be.
there are spaces. ...
-
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:declare @DaysToLookBack int = 5
select *
from [dbo].[TestTable1] a
cross apply (select count(*) Count
... -
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:There aren't 3 values less than 88 within 5 days of (including the reference date) 2024-02-28
2024-02-28 minus 4 days is 2024-02-24.
So there are only 2 rows less than that...
-
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:The gaps in dates shouldn't be an issue.
The data you provided isn't the data you put in your amendment of the query.
The results from the test data you provided...
-
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:Has TRADE_DATE got a time part on it? If so is it not always midnight?
Can you supply some test data?
np. here you go:
CREATE TABLE [dbo].[TestTable1](
[company] [nvarchar](50)... -
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:declare @DaysToLookBack int = 5
select *
from [dbo].[TestTable1] a
cross apply (select COUNT(*) Count
... -
Reply To: find the number of values less than the current row
SoCal_DBD wrote:This is the output I get. (In fact I did a copy/paste from my post).
my bad. i made a typo when i copied over the formula. ...
Viewing 15 posts - 136 through 150 (of 375 total)