Search found 9 matches

Search found 9 matches Page 1 of 1
by jwawrzon
Fri Feb 10, 2017 10:44 am
Forum: Community Forum
Topic: Problems with an SQL Insert
Replies: 5
Views: 184706

That ran perfectly and displayed the data. So the problem is definitely happening when I try to run sql using the data. Here is the error log that I get when I try to run the above script with an sql insert. 2/10/17 10:39:34 AM INFO Start Date and Time: 2/10/17 10:39:34 AM 2/10/17 10:39:34 AM INFO J...
by jwawrzon
Mon Jan 30, 2017 11:11 am
Forum: Community Forum
Topic: Problems with an SQL Insert
Replies: 5
Views: 184706

Unfortunately that did not do it. I am now getting this error. 1/30/17 10:49:46 AM INFO Start Date and Time: 1/30/17 10:49:46 AM 1/30/17 10:49:46 AM INFO Job Number: 1000000028349 1/30/17 10:49:46 AM INFO Project Name: /CN/CN NSLP RA Data Import TEST 1/30/17 10:49:46 AM INFO Submitted By: administra...
by jwawrzon
Thu Jan 26, 2017 10:38 am
Forum: Community Forum
Topic: Problems with an SQL Insert
Replies: 5
Views: 184706

I am having a huge problem with an SQL insert project. I am importing data from a fixed width file, and using the data to insert to an oracle database. I have made projects similar to this one in the past and they have worked fine, but for some reason this project will not run. When it gets to the i...
by jwawrzon
Tue Oct 27, 2015 11:26 am
Forum: Community Forum
Topic: Generating a list of processed files
Replies: 2
Views: 6633

Thanks Rick. This worked perfectly.
by jwawrzon
Tue Oct 27, 2015 9:45 am
Forum: Community Forum
Topic: Generating a list of processed files
Replies: 2
Views: 6633

I have a process set up that grabs a bunch of files from a server via sftp, runs them through a loop that unzips each file and creates a new directory to unzip it into. The loop then emails the user for each file (the output file variable) that was unzipped. This ends up sending out a bunch of succe...
by jwawrzon
Mon Aug 10, 2015 8:35 am
Forum: Community Forum
Topic: Overriding the username and password of a resource
Replies: 1
Views: 7238

I am having an issue overriding the username and password of a resource. We have been creating generic resources without any username or password on them in order to keep from having 50 copies of the same resource with different user accounts. The users will then add those to their project and overr...
by jwawrzon
Mon Jun 29, 2015 9:20 am
Forum: Community Forum
Topic: Copy/Move files without directory structure
Replies: 4
Views: 10161

That worked perfectly. Thanks!
by jwawrzon
Mon Jun 29, 2015 8:53 am
Forum: Community Forum
Topic: Copy/Move files without directory structure
Replies: 4
Views: 10161

Sorry I should have mentioned this is for an sftp session. I do not have a copy option unfortunately. In the manual it says there should be a flatten option with move as well but it is not there.
by jwawrzon
Mon Jun 29, 2015 8:29 am
Forum: Community Forum
Topic: Copy/Move files without directory structure
Replies: 4
Views: 10161

I am trying to set up a monitor that will copy any new files with a specific file name over to an archive directory. The monitor seems to work fine, but when it copies the newly created files to the archive, it also copies the entire directory structure as well. Is there a way to just copy the files...
Search found 9 matches Page 1 of 1