I'm new to ssis and need some help. I have a csv file I need to use as a parameter to get some information and then update it.
Here's how it looks in crystal reports...
SELECT "Order_Master"."ORDNUM_10", "Order_Master"."TYPE_10", "Order_Master"."STATUS_10", "Order_Master"."CUSORD_10"
FROM...
I figured it out...
UPDATE customer_master_ext
SET [2020] = 1
FROM customer_master
inner join Customer_Master_ext
on CUSTOMER_MASTER.CUSTID_23 = CUSTOMER_MASTER_EXT.CUSTID_23
WHERE
substring(customer_master.custyp_23,2,1)='2'
Our company for years have used a text field as a way of adding more information about the customer. There are 3 digits in the code and the depending on the character and the position lets us know some information about the customer. Recently I found a way to add custom fields.
Now I would like...
Thanks SQLBILL and bborissov I got both of the codes working. Previously the company downloaded the data...made manual changes and then uploaded the data. The process took hours to complete, now it takes minutes. Your help is greatly appreciated.
I will do my best to pay it forward.
I must be missing something...I tried running pretty much as SQLBILL gave me. Here is the actual code I used:
SELECT * INTO #cfgmaster_temp
from GNC5.dbo.Configuration_Mst
WHERE 'FEANUM_44' = '01' AND 'CFGCHR_44' = '21'
UPDATE #cfgmaster_temp
SET CFGCHR_44 = '50'
INSERT INTO...
Hi Everyone,
I trying to add data to the table based on query of the same table. Basically we have a several thousand entries with 21 in the option filed and want to make duplicates of the entries with 50 in the option field and change the string in the description field to something else...
Thanks for your post. I've read through https://msdn.microsoft.com/en-us/library/ms162773.aspx and this looks like it may work for what I would like to do.
Hi Everyone,
I'm new to SQL and have been tasked with creating an "app" where the user can run a query to our 2012 SQL server with the click of the mouse. Our old db was Pervasive SQL and there was a way for the users to access the db on their desktop...sometimes with horrible results.
What I...
Just a quick update, the problem was crystal linked the first field so it limited the output based on the the number of records. Once I cleared the links things went smoothly.
Hilfy,
First thanks for your help and time on this. I went back and made the modifications. The report finally ran, but no data. I then cried just a little, but then I went back and looked at everything I finally tried EXTERNAL JOIN MSClose40_.startON={?Onyx: Order_Master.CUSORD_10} which...
Well I got it to work...kinda. I switch from csv to excel. the problem with the csv is CR read it as a number instead of a text. I'm sure there is a quick and dirty way of fixing that, but this is my first rodeo so I'm focusing on the goal and saved it as an excel and CR made the link.
Now...
{Order_Master.TYPE_10} = "MS" and
{Order_Master.STATUS_10} < "4" and
{Order_Master.CUSORD_10} >= '{MSClose40_2003_csv.startON}' and
{Order_Master.CUSORD_10} <= '{MSClose40_2003_csv.endON}'
After a lot of head scratching last night I came up with this. Which I think would meet the criteria. I...
HI Everyone,
Currently the user types the parameters into the report manually. I want to convert the report to gather the data from the fields of the .csv file. I've added to the .csv to crystal report what I don't understand is exactly how to make it read the values in the place of the...
Well I've been playing with the permissions to the folder in question \\gnc3\drawings\ and still have not gotten pass the permission denied error. I guess what really irks me is that I can get the sub-folders to list out but not the files. When uncomment the
(line 20) For Each file In...
Hi niteowl:
Thanks, this code seems to be really close to what I need. So far I've gotten the folders to list out. I had to comment out the files routine, but at least I'm on the right path.
Reading the files gives me a permission denied error.
Once I tweak the permissions I should at...
Hi,
Thanks for the responses:
Rac2: the domain name is my internal server - http://gnc3 and I want to point to the virtual folder http://gnc3/foldername. I would the contents of the folder to be a web page.
Thanks for responding...I hope this clarifies what I'm trying to accomplish...
My company has tons of PDF drawings listed in folders by sales order number. I already have script to access the information, but it returns a basic folder listing back. I would like to modify this to return a webpage which will allow me to put other information in the page. This is what I have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.