Viewing 15 posts - 301 through 315 (of 375 total)
script to create table:
/****** Object: Table [dbo].[TableTemp] Script Date: 2022-02-02 8:09:25 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TableTemp](
[UNDERLYING_SYMBOL] [nvarchar](10) NOT NULL,
[QUOTE_DATE] [date]...
February 2, 2022 at 4:24 pm
can you give us a sample file?
No problem.
February 2, 2022 at 4:23 pm
Hi
I fixed one error.
WITH (FORMAT = 'CSV', FIRSTROW = 2, FIELDQUOTE = '\', FIELDTERMINATOR = ',', ROWTERMINATOR = '\r\n');
Now, I am getting this error:
Msg 7301, Level 16,...
February 2, 2022 at 4:12 am
Hi
Thanks for the reply. It still doesn't work:
USE MyDB
GO
BULK INSERT dbo.TableTemp
FROM 'C:\Users\Me\File.csv'
WITH (FORMAT = 'CSV', FIRSTROW = 2, FIELDQUOTE = '\', FIELDTERMINATOR = ';', ROWTERMINATOR = '\r\n');
February 2, 2022 at 3:20 am
issue resolved. please ignore post.
January 29, 2022 at 11:11 pm
Google is your friend
I rely very heavily on Google for sure. I find that it is a good tool but it doesn't replace guidance from people who know what...
January 29, 2022 at 6:29 pm
Curious - why do you need to create a script task and execute a SQL query in that script task? If this is a one-time call to get/set some...
January 29, 2022 at 6:27 pm
Thank you so much! It works as planned.
January 29, 2022 at 6:19 pm
One more question ...
From a design perspective... is it better to have one script do it all or should there be different SSIS tasks for each?
January 25, 2022 at 5:08 am
try the following - just an example and you will need to play with destination filename/directory
its only the using session block - no need to post the remaining code
do...
January 25, 2022 at 5:06 am
Thanks for the info. I'll play around with it.
could you advise how do you know which files have been processed - and do you keep a copy of them...
January 25, 2022 at 4:53 am
One more comment re Days_Retrieval...
The files will have a system generated timestamp. Using this timestamp for calculating Days_Retrieval may not be helpful in all cases. I will have to give...
January 24, 2022 at 8:48 pm
Thank you so much for your help!
No problem. Here you go.
The files are put on the SFTP site daily (M-F) and remain there for 30 days. After 30 days, the...
January 24, 2022 at 8:29 pm
Viewing 15 posts - 301 through 315 (of 375 total)